I'm trying to import multiple files which have different sheets and slightly different schemas (i.e. the headers in different orders) using batch macros.
I've used a directory tool to first bring in the list of files and then a batch macro to pull in the list of sheet names and add the sheet name to the file path. This seems to work fine and gives me an output similar to below:
| File Path |
\folder\workbook1.xlsx|||sheet123 |
| \folder\workbook2.xlsx|||sheet456 |
I'm then using another batch macro to push this list into an input tool using update value in the action tool to update the file patch including sheet name - however it's still only pulling the data in the first file. It's as if it's not recognising a change in sheet name or something? I've also checked the auto config by name in the interface designer in the macro.
Please help!
