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

Alteryx - Warning with multiple inputs.png

TomWelgemoed

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