topic Re: Q > How to import data from excel file with multi sheets but different fields? in Alteryx Designer Desktop Discussions

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

adluayon — Mon, 12 Sep 2022 01:43:12 GMT

Hi Support,

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

Thanks.

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

flying008 — Mon, 12 Sep 2022 02:04:33 GMT

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.

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

adluayon — Mon, 12 Sep 2022 02:26:07 GMT

@flying008

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

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

grazitti_sapna — Mon, 12 Sep 2022 04:16:02 GMT

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

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

adluayon — Mon, 12 Sep 2022 04:21:46 GMT

@grazitti_sapna

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

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

grazitti_sapna — Mon, 12 Sep 2022 04:28:16 GMT

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

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

adluayon — Mon, 12 Sep 2022 06:31:46 GMT

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