Field Mapping Batch Macros

[Shannon11113]

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 

[RaphaelSilva]

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.

[Shannon11113]

sorry, i don’t quite understand what you mean

[Raj]

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