Hey!
I have given this output result:
And I want this output result if possible:
Do you no any solution for this output result?
Mathias
@mathias_schnoor Attached is one possible solution, there will be a few other ways that you could do this, depending on the exact scenario.
If the incoming records were SELECTED and individually sorted, then your could take both streams of data into a JOIN (join on record position) and create that data.
Looks like we had the same idea.
Here's how I would approach it:
