Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Applying the same steps to multiple tables

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

Tips and Tricks

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    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.