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

Issue.yxzp

AbhilashR

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!

IssueModified.yxzp