Dynamic Input Tool throwing schema mismatcherror

[karangupta]

I have 11 files with the same number of columns and column headers.

I wish to use one input so I am trying to use directory and then reading all files using the dynamic input tool. I am receiving the error that my schema is different. I tried to check this and found out that if I use 11 different inputs, Alter reads different variables types for same variables coming from different inputs. e.g. a variable named X in file 1 is double while the same variable in file 2 is string.

Is it due to this reason that the dynamic tool is giving an error.? If yes, is there a way around it? I can use 11 inputs and union but the flow looks cluttered.

Thanks for help!

[darryl5280 · Accepted solution]

Community Designer Browse Knowledge Read in Multiple Excel Files, with Multiple Tabs t... Read in Mu...

Another post with the magic you want.