Reading multiple tabs with different schemas

pdubois003

Hi guys, 

I am trying to import multiple sheets from an xlsx file using the dynamic input tool.

When i run the workflow there is an error in 'Dynamic input' saying that the schema is inconsitent with the first file.

I looked into the metadata and the error is due to 1 column that is considered as a different data type by Alteryx (Transaction # considered as V_String in first sheet and double in other sheet).

I would like to find a way to make it work without using a macro.

I just throw some ideas here (Is there a way to do these things ?)

-Dynamically standardize data as V_String for all sheets before import.

-Ignore error messages and still import data as V_String

-Flag sheets where there is an error and change data type to the same as template.

Thank you very much!!

BenMoss

There is a macro pack called the 'CReW macro pack', it's extremely popular with Alteryx users and contains a number of macros that many people use on a day to day.

One of those macro's is the 'wildcard xlsx' which does what you need. So perhaps you could use this as a demo of using external sources to help with your analysis.

But if you wish to demo the functionality itself it's relatively straight forward; I assume you are at a point where you have the full paths for each tab in the workbook.

so, for example,

'C:\Users\BenMoss\Desktop\Superstore.xlsx|Orders2019'

and

' C:\Users\BenMoss\Desktop\Superstore.xlsx|Orders2018'

If so, then it's a really straight forward process; the macro should look like the image below. I have highlighted key confiugrations in red...

And here is an example of how that can be intergrated into a workflow (of course you shouldn't use a text input for the paths and instead make a dynamic process, but as mentioned, this is the point at which I Was building from)...

I've attached this simple macro to the post for your benefit.

In order to view the results you MUST have a browse tool on the output anchor, otherwise only one record will come out.

Ben

InputAll.yxzp