Hi,
I need to input multiple excel files; they have the same schema and sheet name. I have tried using a Dynamic Input tool, but I get the error of this 'file has a different schema than the 1st file in the set'. I have checked the data; the columns are in the same order, but there is a different data type for one column which is causing this error.
In the dynamic input tool, I have chosen the 'First row is data' to try and bypass this issue, but unfortunately it is still there.
Therefore, I decided to do some research on Batch Macros and have gone through multiple tutorials; yet I can't get it to work.
I have a batch macro which I update the action tool to update the full path; in the interface designer, I also choose the option of Auto configure by Name.
In the actual workflow, I use the full path plus the sheet name, but only the first file gets read and the others get ignored.
Any suggestions?
Thanks,
Zeeshaan
