Dynamic Input Tool Error - The file has a different schema than the 1st file in the set

[urfriendumesh]

My excel spreadsheet has 3 sheets in it and I'm trying to merge these 3 sheets into one using the Dynamic Input Tool. But, received below error message:

The file "xxxxx" has a different schema than the 1st file in the set

I analyzed and see that one of the column value (string) in the 1st sheet is having the field length of 280 (but default is 255). Removing the extra characters from the field value fixed the issue and able to run the workflow. But, this results in loss of data.

Is there any way I can increase the size of the field before running the Dynamic tool so as to avoid any data loss?

Thanks,

Umesh

[atcodedog05]

Hi @urfriendumesh 

Suggestion for this would be use the file which larger column size as template.

Or create a template file where the columns are at maximum size and use it as template.

[urfriendumesh]

Hi @atcodedog05

Yes, I used the sheet with the max field length one as Input Data Source Template in the Dynamic Input and see the same issue.

Any way I can either increase or set the field length to a highest value before passing the sheets to Dynamic Input?

[atcodedog05]

Hi @urfriendumesh 

I dont think thats possible😅

[PhilippK]

Hi @urfriendumesh 

Try out this macro to read in all sheets:

https://gallery.alteryx.com/#!app/Read_All_Excel_Files/58dd51b3a18e9e18fca64172

As an alternative, you could try out the Crew Macro Wildcard Input:

https://community.alteryx.com/t5/Engine-Works/Crew-Macro-Pack-2016-Q2-Release/ba-p/26482

Best regards

Phil