Splitting & Aggregating Data

[kpontarollo]

Hello! I need help with the following. In my input data, I have column labeled "Segment" and then A... B.... C... etc. I have to manipulate the data within each segment, so segment A, Segment B, Segment C.

In my attached file you see that, the data comes in, I filter on which segment I would like, it goes through its own little manipulation, and then comes together in a union. My issue is that when there are a million "segments" this takes me forever to build. Is there an easier way to have it automatically split into the segment, run through its query, and then come back together?

[jdminton]

Then you would likely need the batch macro to do what you need.