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.
Solved! Go to 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.