Collate multiple excel workbooks (includes multiple sheets) into workbook

[jasanikevin2794]

I have 10 excel workbooks (each containing 5 sheets). I want to collate all workbooks into one workbook ( adding all sheets to one workbook). How do I do this in alteryx?

[flying008]

Hi, @jasanikevin2794 

The Wildcard XLSX input or Read_All_Excel_Files macro in gallery can help you . https://community.alteryx.com/t5/Community-Gallery/Read-All-Excel-Files/ta-p/897750 

[caltang]

@jasanikevin2794 Try this my friend: https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309