community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Dynamic Input Tool throwing schema mismatcherror

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!

Labels