How can I have different schema when importing a list of sheet names?

I am trying to run a batch macro with a series of files that all have different tab names, so I want to use a dynamic input to first read in all of the tab names. However I'm getting an error that some of the files have a different schema. I'm not sure how this can be given that Alteryx defines the schema of the list of sheet names ?

Input

Error Message

Accepted answers

AbhilashR

Sorry to jump-in out of turn here @grossal. I posted a similar solution today in another thread that might help @nrubner1.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-Check-if-an-excel-file-exist-and-if-exist-the-input-it/td-p/551732

I have attached the solution here for quick reference.

sampleExcelRead.yxzp

All comments

grossal

The error means that some of the tabs have a different schema. For example one has 3 columns and another one has 4 or more.

You could use the Wildcard Input macro from the CReW macros (http://www.chaosreignswithin.com/p/macros.html) to work around this.

nrubner1

Can you explain why the number of columns within a tab affects the list of the sheet names that is being read out?

Thanks for the link, got the crew macros already but hoping to find a solution that is scale-able

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703