Field Mapping Batch Macros

Question

Hi community!

I am trying to create a batch macro that will allow me to combine multiple excel files and sheets that have different schemas and might have different column names in the future. The output data should be stacked ontop of the previous sheet if the column are matching. I have research other posts however i seem to have issue as my first row contains data… this seems to make my macro more difficult. any help would be greatly appreciated

Raj · Answer

@Shannon11113 you can use this macro.
this will help.

Batch Macro.yxmc

Shannon11113 · Answer

sorry, i don’t quite understand what you mean

RaphaelSilva · Answer

You can load the excel inside the macro, check the header names and add it to an empty union tool, just to map the field names and keep the structure.
This union tool would hold all possible field names, and appended new fields for all new loaded files.