Applying the same steps to multiple tables

[Anonymous]

Hi there,

i have 24 CSV spreadsheets, each pertaining to a different month's trial balance. Each spreadsheet has a different name but the columns are all named the same. I have imported them from the folder using the power query then grouped by the sheet name to make 24 new tables. Now i need to clean the data i.e. remove the top three rows and bottom 1 row, change nulls to 0's, etc. FOr each of these steps is there a way to copy them automatically to each of the other tables so that i have 24 clean flat tables?

thanks,

Andrew

[Anonymous]

Hey there. You should add a parameter, type any, and use one of your table/sheet names as the current parameter. Then go to one of your cleaned up queries and substitute the sheet/table/parameter name. Then, you can turn that query into a function, with your tables as parameters.
Dude is right though—this is exactly the case for Get Files—From Folder.

[Greg_Deckler]

Sounds like you should be using a single Folder query versus 24 individual queries...

What you are describing is exactly what a Folder query is designed to do.