Forum Discussion
[Power Query] how to exclude x number of rows at the top when combining csv files
Why don't you use From Folder connector and adjust only one Transform from Sample File query?
Claudia000 You start by doing all the transformations needed on one file. Then you create a parameter for the file name used in the Source step. Replace the hardcoded file name with the parameter. Now, you can create a function of the first query.
Create a table with all the file names you need to transform, query it and add a column through "Invoke Custom function". Select the function you just created, select the column that contains the file names and press OK. Expand the new column.
Actually, Wyn Hopkins recently posted a link to an easy to follow video that demonstrates this principle. His video deals with named ranges within one sheet, but you apply the same technique to files in a folder.
https://www.youtube.com/watch?v=cPN24NK3_68