You just need to JOIN them back on the Unique ID
@skatpally, A couple of problems:
Group By Field works but I end up with extra stuff inside each element of the array, which will not work for me. The problem is that in order for Group By Field to work, I need to somehow pass the unique ID field value to use for grouping through the Mapper that is working on the individual array elements. If I explicitly map that field in the Mapper, the output from Group By Field has the unique ID field inside each array element. If I do not map the field and use Pass Through, I end up with all of the pass through fields inside each array element. If I do neither, Group By Field errors out because the payload does not have access to the unique ID field. There probably needs to be a “Remove Group By Field from elements” option in the Group By Field snap.
The Join snap does not work because not all messages have all 5 elements that are being joined by unique ID so the snap errors out if I use any of the join types other than Merge. Merge doesn’t do what I need since the reassembled messages have pieces from various messages combined into a single message. I figured Null Safe Access might be the solution but the Join snap still fails to do the join.
What am I missing?
Mapping Conundrum_2020_09_30.slp (48.1 KB)
