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
Solved! Go to 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