Hello,
Whenever I click the "double down arrow" next to Content in my query that I just created from a folder that contains CSV files, downloaded from ExcelisFun PowerQuery04, I am getting a new screen titled "Combine Files"; Combine Files screen is asking me for Example File, File origin, Delimiter, and Data Type Detection. When I click "OK", My query now jumps from one to 5. I have a parent Query Folder titled "Transform File from PowerQuery04, I have a Sample Query Folder, etc.
When Mike did this in ExcelisFun, after he clicked the double-down arrow, he didn't get the "Combine Files" screen, and he did not have any Query Folders. I am using the same CSV files that Mike had provided in Youtube.
I am assuming this issue is because I am using a newer version of Excel than Mike was at the time the video was posted.
Any help is appreciated.
Whenever I click the "double down arrow" next to Content in my query that I just created from a folder that contains CSV files, downloaded from ExcelisFun PowerQuery04, I am getting a new screen titled "Combine Files"; Combine Files screen is asking me for Example File, File origin, Delimiter, and Data Type Detection. When I click "OK", My query now jumps from one to 5. I have a parent Query Folder titled "Transform File from PowerQuery04, I have a Sample Query Folder, etc.
When Mike did this in ExcelisFun, after he clicked the double-down arrow, he didn't get the "Combine Files" screen, and he did not have any Query Folders. I am using the same CSV files that Mike had provided in Youtube.
I am assuming this issue is because I am using a newer version of Excel than Mike was at the time the video was posted.
Any help is appreciated.