This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.