Input tool - Read in Multiple xlsx files that have Different Schemas
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Input
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here are some additional resources to solve your issue, if you would like to understand behind the scenes -
