Alteryx Designer Desktop Discussions

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

File has a different schema than the 1st file in the set.

Alteryx Alumni (Retired)

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 -\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.




14 - Magnetar
14 - Magnetar

Hi @MatthewBr,


it could be also linked to data types, for instance having a date stored as text or anything like that

14 - Magnetar
14 - Magnetar

If you want to do a quick check, you could use the field info on your different files/tabs and then compare the results.

Alteryx Alumni (Retired)

@Ladarthure  - Is there a suggested way to mitigate that issue? 

Alteryx Alumni (Retired)

@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.

15 - Aurora

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


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:


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:
part 2: