Running the same workflow with different data sets without copying and pasting

Question

I am running the same workflow on different snap shots of historical data. (i.e) the structure is the same but the data needs to be combined all together.

I have been doing this:

With a Union tool to combine them all at the end.

I have a feeling this is not the most efficient way to aggregate all this data.

So, is there a way to run the same workflow on multiple sheets of data without making new workflows for each.

Keep in mind: that my workflow would not work if I used the Union tool at the beginning to combine the files at first, given the formatting.

Any suggestions?

gabrielvilella · Answer

Yeah, the output will be stacked on top of each other, for each run.

shelbybradley · Answer

Could I then stack the outputs on top of each other?

gabrielvilella · Answer

Maybe you could use a batch macro to run the same workflow multiple times, each time for a different dataset.