Multiple Sheet Same Schema Error

[MattR79]

I am just starting to learn about using dynamic inputs and I have run into a rather frustrating issue with a test work flow that I am using.  I am trying to get this workflow to read in two sheets with the same schema and I am getting an error stating that the second sheet has a different schema than the first file in the set.  I know that the schema cannot possibly be different because I literally copied and pasted the headings for the columns from the original file onto the two sheets and then grabbed the first 13 rows to use as data on sheet 1 and the second 13 rows for sheet two.  Since I know that the data is exactly the same I don't understand why I am getting this error.  Attached is the file I am using along with screenshots of the input and dynamic input tool setups.

[cjaneczko]

Since there is no data in field 11 (TRAN_TYPE_1) on sheet two, its setting the data type to Double. All of the fields on Sheet 1 are V_String. This is why you are getting the mismatch error. One way to get around this is to tell the Dynamic Input tool that the first row contains data. Then add a Dynamic Rename tool after this to promote the first Row of Data to the header. Then fillter out any additional Header Rows in your data.

[aatalai]

@MattR79 THINK IT TIS TO DO WITH tRAN tYPE 1 IN ONE FILE IT SI A SRTING AND IN ANOTHER IT IS DOUBLE, HENCE NOT THE SAME SCHEMA

[binuacs]

@MattR79 you can try the batch macro for the schema error

https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309

[MattR79]

Thank you for that information, it worked perfectly.