Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere is my solution
I got to the end result, saw that there were quite a few different approaches. I used an iterative macro inside a batch macro, which shaves off the first store and appends all others each iteration.
Combined with the batch macro you get a process that runs per usedID.
Regards,
Arjan Loogman
Can't remember the last time I used a Cartesian Self Join