Repeating Same Workflow Through Multiple Files Inside Same Folder and Union

Max_Lam

Hi, I need to run multiple files in the same folder through the same workflow logic.

All the files have the same schema. I have attached two excel sample files as reference.

Basically I was just adding an extra column of month-year data to each file based on the month of release.

After adding the month-year column in each file I will then use Union tool to merge all files together cumulatively.

I have heard that I should try batch macro or use the wild card *.xlsx in input data, but I am not sure which one would be best.

Thank you!

TD Database_Overhauled Structure_v1.yxwz

particulars of first registered vehicle_february 2020.xlsx

particulars of first registered vehicle_january 2020.xlsx

AngelosPachis

Hi @Max_Lam ,

If all the files in your folder are of the same schema and the sheet names are exactly the same, then the best solution in my opinion would be the wildcard union (*.xlsx) which will union all files in that directory.

By the looks of it, a wildcard would work, just make sure that you skip the first 3 rows in each file if you don't need them cause they may mess with the looks of your table, it's up to you.

If the schema is different, then you will receive a relevant warning and that means that you should build a batch macro to bring all your files together.

Hope that helps,

Angelos