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

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.

Datasets

Accepted answers

ChrisTX

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

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Using-input-Directory-and-Dynamic-input-tool-with-2-sheets-in/td-p/622984

Get worksheet names from excel

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Get-worksheet-names-from-excel/td-p/344867

Input multiple xlsx files and union them

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Input-multiple-xlsx-files-and-union-them/td-p/306503

Read multiple sheets from multiple Excel files

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/using-dynamic-input-on-excel-files-with-different-tab-worksheet/td-p/3503

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

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Get-worksheet-names-from-excel/m-p/344867/highlight/false#M62954

using a batch macro to import multiple sheets from excel

https://www.thedataschool.co.uk/nick-jastrzebski/beer-and-loathing-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

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/CS-Macro-Dev-Reading-in-Multiple-Files-with-Different-Field/ta-p/13370

How to Input Multiple Sheets from Multiple Excel Files

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-Input-Multiple-Sheets-from-Multiple-Excel-Files/m-p/20014

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-Excel/ba-p/5558
part 2: https://community.alteryx.com/t5/Engine-Works/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-ALL-Excel-Macro/ba-p/9988

Chris

All comments

Ladarthure

Hi @MatthewBr,

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

Ladarthure

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

MatthewBr

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

MatthewBr

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