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.

Import Multiple Sheet Same Schema.xlsx

Same Schema Dynamic Input.PNG

Same Schema Input Tool.PNG

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.

Multiple Sheet Same Schema Error.yxmd