how to connect multiple sheets

[Sabah_Alia]

I have an Excel worksheet that contains multiple sheets, but the data do not match in the order for some columns. I tried to use the Dynamic input tool but it didn't work well.  what tool should I use for this situation? 

I am still new in Alteryx and I am working on HW assignment 

[DavidSta · Accepted solution]

Hi @Sabah_Alia,

the most information on your request can be found here: https://knowledge.alteryx.com/index/s/article/How-To-Import-Multiple-Excel-Sheets-or-a-Specific-Exce...

The Dynamic Input Tool is the correct one, but only in combination with a Batch Macro, as there are different schemas caused by the different column order.

Please also check out the attached file with a sample workflow.

Best regards,

David