Different schema than the 1st file error

[seelan89]

HI All,

I am trying to combine a number of workbooks, all of which have tabs titled the same.

I tried to create a workflow with input data for each of the tabs and with the use of "*" to pull automatically from a folder as and when more files come into it.

However I am getting an error which says that one of the tabs from one of the worksheets has a different schema than the 1st file 

I think i need to use a batch macro but I am not sure how. Any suggestions how to solve this issue?

Thanks

[dsandmann]

You can actually use a batch macro to get around this - if the columns are all the same just use the batch to swap file names on an input data tool, and then convert all the columns to string. You can correct the data types from outside of the macro output.