Forum Discussion
Appending from Folder - only selected rows
Are you using the Combine feature?
If so you will have a group in Power Query that looks like this:
Add the Keep Rows function for the top 12 rows to the "Transform Sample File" step. It will apply everything in that step to each file individually before they are combined in your main query.
Are you using the Combine feature?
If so you will have a group in Power Query that looks like this:
Add the Keep Rows function for the top 12 rows to the "Transform Sample File" step. It will apply everything in that step to each file individually before they are combined in your main query.
Hi edhans,
super, it helped. Thank you very much.
I am combining files by Append Queries function and your solution works perfectly.
Have a nice day, Jiri
Glad to help Jiri_Slavik