Hi,
I am currently following your Power Query course, which I find very useful.
I've created a folder with a file from our accounting system where the name of the file includes the month of the year.
In lesson 2.05 you say that any changes in the query should be done in the "Sample Binary" file, and not in the final query under "Other Queries". However I am planning to use the date in the file name as a date column in the query. The file name doesn't appear in Sample binary ( as far as I can see), but under "Other queries". Do you have any advice on how to proceed if you want to use the file name in the final query?
Thanks in advance for any help.
Best Regards
Caspar
Hi Caspar,
I think there's some confusion about the process; when Power Query loads the data from the folder it takes one workbook as the sample. The transformations you make to the 'sample' query are applied to all files in the folder before they are consolidated and loaded into the final query under the folder 'other queries'.
It's this final query that gets loaded into Excel/Power Pivot etc. So, as long as the final query has the dates then there's no issue for you. You can then perform further transformations to the final query if you wish, but things like unpivoting need to be done at the sample query level.
I hope that clarifies things, but please let me know if you have further questions.
Mynda
Hi Mynda,
Thanks for the clarification.
Caspar
