Inputting Multiple Excel files with Multiple Sheets (Same Structure)

[Maltaleb001]

Hello everyone,

I have many Excel files and each contains 4 sheets with same structure. I want an automated way to import 3 sheets from all of the Excel files. The sheets name are: Sheet_1, Sheet_2, Sheet_3, and Sheet_4. I don't want Sheet_4, only the first 3 sheets. The idea is to build a workflow so the next person will only need to run the workflow to have all of the data in one table. 

Thanks in advance

[Pang_Hee_Choy · Accepted solution]

this should be an old topic, but here the method.

1. input sheet name with full file path(for 1st file)
2. filter first three sheet
3. use formula (replace list of sheet name to sheet name)
4. dynamic input
5. change the input filename in step 1 (Input_1.xlsx to Input_*.xlsx)

provided all structure. (included same header name, header sorting, data type and the number of empty column)

even the sheetname data type...

[messi007 · Accepted solution]

@Maltaleb001,

Please have a look on :

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets... 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Read-All-Excel-sheets/td-p/504251 

Hope this helps,

Regards