Dynamic Input tool not bringing in all the sheets

[HBarge]

Hi,

I am trying to get all the data from an excel documents containing multiple sheets (PFA)

I am getting partial success. Only a few of the sheets are being extracted.

1. Why is this happening?

2. What am I doing wrong?

Thanks,

Harshad

[AbhilashR · Accepted solution]

Hi @HBarge, your approach would have if all tabs of the file would have had the same data/column structure. Since it changes tab-to-tab in your case, Alteryx feels the need for the use of a Macro based approach to reading in the data. I have modified your solution to bring data in using a macro for you to build upon.

I hope this helps!

[HBarge]

Hi @AbhilashR Thank you for that however, I am unable to open the packaged workflow.

I am using Alteryx 2019.4

What does the Macro include that I can replicate at my end?

[ChiN]

Hi @HBarge ,

The excel sheets have different schema so you need macro rather than the dynamic input to read excel files in different schema.

You can get the macro here: http://community.alteryx.com/t5/Alteryx-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

If this doesn't work, take a look at this link:  http://www.chaosreignswithin.com/p/macros.html

[AbhilashR]

Hi @HBarge, I used v2020.2 to build my solution. Try following the steps mentioned in this link to downgrade it to v2019.

https://community.alteryx.com/t5/Alteryx-Designer/Adjusting-Alteryx-Files-for-Different-Versions/ta-...