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

[MatthewBr]

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.

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

[ChrisTX · Accepted solution]

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

Get worksheet names from excel

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

Input multiple xlsx files and union them

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Input-multiple-xlsx-files-and-union-th...

Read multiple sheets from multiple Excel files

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/using-dynamic-input-on-excel-files-wit...

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/344...

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

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

How to Input Multiple Sheets from Multiple Excel Files

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-Input-Multiple-Sheets-from-Mult...

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