I am looking at the the dataset in question. My question what "things" would cause a SCHEMA difference? I checked the headers from file to file and they are identical.
Error - When I used a DYNAMIC INPUT tool
Error: Dynamic Input (7): The file "C:\Users\matthew.braun\OneDrive - alteryx.com\Tech - Alteryx\Clients\Vimeo\Data\Arizona VOD Tax Calc (May'22).xlsx|||Arizona" has a different schema than the 1st file in the set.
Error - When I did it through a BATCH Macro
Error: VIMEO (11): Record #2: Tool #2: The field schema for the output "Output2" changed between iterations.
I know I have had this error in the past and of course never wrote the real reason down. Thanks in advanced community.
Solved! Go to Solution.
Hi @MatthewBr,
it could be also linked to data types, for instance having a date stored as text or anything like that
If you want to do a quick check, you could use the field info on your different files/tabs and then compare the results.
@Ladarthure - Is there a suggested way to mitigate that issue?
@Ladarthure - Figured out the problem. There is a field on the first file that has NULLS in every row and it's interpreting the data to be a DOUBLE. On the second file there is data in the field and it's really a DATETIME field. Hence the issue at hand.
what "things" would cause a SCHEMA difference: Field names, data types, sizes
Here's a good knowledge base article when dealing with multiple Excel sheets:
The Ultimate Input Data Flowchart
https://community.alteryx.com/t5/Alteryx-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480
and some other posts that have helped me:
Using input Directory and Dynamic input tool with 2 sheets in input
Get worksheet names from excel
Input multiple xlsx files and union them
Read multiple sheets from multiple Excel files
Import one Excel file, multiple tabs, different layout on each tab:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Input-tool-multiple-tabs/td-p/298750
the first Macro reads all of the sheet names and the second macro imports those sheets into a single file
using a batch macro to import multiple sheets from excel
Community > Designer > Browse Knowledge > CS Macro Dev: Reading in Multiple Files with Different Field Schema - Batch Macro
How to Input Multiple Sheets from Multiple Excel Files
The Ultimate Alteryx Holiday gift of 2015: Read All Excel Worksheets Macro
Suppose you have a folder containing multiple Excel workbooks, each containing multiple sheets or tabs that you would would like to read into a workflow all at once. What are your options?
(read in excel files/sheets and stack them on top of each other (union))
part 1: https://community.alteryx.com/t5/Engine-Works/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-All-Exc...
part 2: https://community.alteryx.com/t5/Engine-Works/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-ALL-Exc...
Chris