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

Question

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

PhilippK · Answer

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

atcodedog05 · Answer

Hi @urfriendumesh

I dont think thats possible😅

urfriendumesh · Answer

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?