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!
