Hi Support,
Any idea on how to import data from excel file with multi sheets but different fields?
Without using macro?
Thanks.
Solved! Go to Solution.
Hi, @adluayon
1- If your sheets with schema are different, then the dynamic input tool maybe can't normal work for this case.
2- If only have different fields, the dynamic input tool maybe output never with your want.
3- If you use batch macro to process it , all is done.
@flying008
Thanks for the guide i think i need to search about this batch macro.
@adluayon , Here is my workflow which will do the magic. I will read all the sheets from different excels with different schemas. Please accept my solution if it helped. Thanks!!
@grazitti_sapna
Thanks for this but i haven't tried batch macro need to do some research about it.
No Issues @adluayon , You can read about Batch Macro in the link below and also How to Design one in Alteryx.
https://help.alteryx.com/20221/designer/batch-macro
Thanks!!
Thanks for all the support i already found a video which is very easy to understand how batch macro works. 👍👍👍
https://www.youtube.com/watch?v=z-iTDI5lD00