Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Error: Dynamic Input - The file "xxx" has a different schema than the 1st file

DaveJ
7 - Meteor

Hello,

 

I am trying to load 2 excel spreadsheets using dynamic input. Each has 2 worksheets. My workflow splits into 2 and loads the same worksheet page from each of the files in one branch and the other worksheet page name from each file in the other branch.

 

Branch 1 works and successfully opens up the contents of worksheet "sheet1" from both files. However branch 2 complains that one of the 2 files has a different schema and only loads one of the worksheets. 

 

1) I have scrutinised both files to look for differences and couldn't see any. Nonetheless I checked the column types for format differences, data shape differences, column header name differences etc but there was no difference.

2) I switched the worksheet pages around so that each spreadsheet now contained the others "sheet2". Same error on the same file.

3) I recreated both files from scratch and copy\pasted values from each into brand new spreadsheet files. No difference.

4) I started to think that what is was telling me was that both files are ok but their data is different so the load order wasn't a critical factor but the 2nd file was different than the first therefore the error would always come on the file loaded 2nd. As a test I deleted the worksheet page from the 2nd file and copied the worksheet from the first file so that they would literally try to load the exact same data. Now there couldn't be a different schema because it's the exact same file. However I did indeed hit the same problem. 

 

So I have zero confidence in the reliability of the error message as stated. It can't be a schema difference!!  What is going on? Can anyone help please? This is getting really frustrating.

 

Regards

David.

21 REPLIES 21
PeterAP
8 - Asteroid

@jenv20032000x Could you share a screenshot of the format your date is in?

jenv20032000x
6 - Meteoroid

@PeterAP  it is custom [$-en-US,1]m/d/yyyy.  This wasn't a problem with the other 38 files (all are formatted the same).  However, this one file has the datatype datetime instead of date (sizes are different too).  I really appreciate you trying to help me.

Labels