Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

Ferdinand
5 - Atom

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

 

 

2 REPLIES 2
TomWelgemoed
12 - Quasar

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

 

Wildcard XLSX Input.png

 

 

Labels