Consolidate multiple file from one folder

mandarhondule

Hi - I want to consolidate multiple files stored in a folder for multiple dates which has Multiple sheet into it ....And I want to specifically consolidate only the sheet which says "ABC" and all the files has this sheet in common..so the final output should be the records of ABC sheet from all the files.

Adrian_T

Hi @mandarhondule,

This should work just fine for you. I have attached a few sample excel spreadsheets which I have done up to illustrate this solution. You can also find the sample workflow attached.

You would first use a Input Data Tool to input only the list of sheet names in all your relevant spreadsheets as shown in the diagram below. To read all excel spreadsheets in your folder, use the wildcard character *.xlsx.

You can then use a Filter Tool to filter out sheets named "ABC" before using the Dynamic Input Tool to read into these sheets and have all data consolidated.

Hope this helps! 🙂

Sample Spreadsheets.zip

Consolidate Sheets.yxzp