Workflow on multiple files and output one file join

[Christopher2211]

I have Data of different Product Line:

The Original Structure of this Data is:

I did a workflow to modify it:

The Final Structure Data is:

I need to modify each file with the same workflow and then join the data of the 3 files into one.

Thank in advance.

[jasperlch · Accepted solution]

Since you already have created a workflow to work on one file, the best way to apply the same workflow on multiple file is to convert your current workflow to a batch macro and then create another workflow to run this macro. I will loop through the list of inputting file path.

Before running the workflow, please update input the directory of the folder containing your excel files.