Q > How to import data from excel file with multi sheets but different fields?

[adluayon]

Hi Support,

Any idea on how to import data from excel file with multi sheets but different fields?
Without using macro?

Thanks.

[flying008]

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.

[adluayon]

@flying008 

Thanks for the guide i think i need to search about this batch macro.

[grazitti_sapna]

@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!!

[adluayon]

@grazitti_sapna 

Thanks for this but i haven't tried batch macro need to do some research about it.

[grazitti_sapna]

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!!

[adluayon · Accepted solution]

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