Input tool - Read in Multiple xlsx files that have Different Schemas

[Ferdinand]

Hi all,

I am extracting 2500 xlsx documents in a workflow. A lot of documents will be skipped, because a difference in datatype in column 16.

Discovered

Column 16 is in around 2000 files a v_string in Alteryx

Column 16 is in around 500 files a v_wstring in Alteryx

The result, when I use the "Input tool" with a wildcard in the filename, is for all the files with a v_wstring (as the first file has a v_string) a warning as follows;

Warning: Input Data (1): The file "FILENAME" has a different schema than the 1st file in the set and will be skipped

Are there any idea's for a solution? If it helps, I do not need column 16. I have included a screenshot of the situation.

All the best,

Ferdinand

[TomWelgemoed · Accepted solution]

Hi @Ferdinand ,

Yes, I would look at the CREW macros tool - Wildcard XLSX Input. Download the Crew Macros from here and look to use the tool as per the image below.

Let me know if that helps.

Best,

Tom

[JessieC]

@Ferdinand -

Here are some additional resources to solve your issue, if you would like to understand behind the scenes - 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CS-Macro-Dev-Reading-in-Multiple-Fi...

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Read-in-Multiple-Excel-Files-with-M...