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?
Maybe you could use a batch macro to run the same workflow multiple times, each time for a different dataset.
Could I then stack the outputs on top of each other?
Yeah, the output will be stacked on top of each other, for each run.