Power Query - Remove top Xrows for each file in a folder

[RBGDaboys]

Hello,
I have a query setup for a folder. I want to remove the top 10 rows for ALL files in the folder. Can this be done?
Thank you

 

[jeremy_norbury]

You choose "Combine" and PQ generates 2 main queries, one function and one parameter. A temporary query is made called Sample File - for analysing the contents by the look of it.

- there's a query for the WHOLE folder (named after the folder name - in my case "sample" ) - it's in the Other Queries group.
- there's a query for individual files (called "Transform file from sample").
- This file level query is used to "Generate a function" for you "fx Transform file from sample"
- the parameter needs to exist in order to generate a function (which is done for you). Beyond that it's only used for test purposes.

You now modify the query called "Transform Sample File from sample" to apply whatever file-level modifications you want (like removing the first 10 rows).

You modify the "sample" query to perform whatever transformations you want once all the data is combined (new columns, filtering, sorting etc)

 

[RBGDaboys]

Thank you for the reply. I did this but the issue is when I add more files to the folder only the top 10 rows on the first file are removed. I need it on every file.

 

[jeremy_norbury]

You need to edit "Transform Sample File from sample", as I stated.

What do you then want to do with the files, not read them into one?