Join Merge on all rows

Hi folks,

I did find that using Join with Merge to append data to an other set only append the merged elements onto the 1st row of the second.
Is there a way to merge on all rows to augment all rows with the merged new value?

eg:
Merging aaa to

bbb
ccc

will show:

bbb aaa
ccc

Desired result is:

bbb aaa
ccc aaa

Thanks,

To solve this one, you want to join all rows in input 0 with one row in input1?
To do this, use an Inner Join, and set the join critera as Left: “A” joins to Right “A”

The result should be what you are looking for.

Hi, thanks for your feedback.
However, when I do it I get this error message (even with null safe access on):
Failure: Null pointer exception occurred at: com.snaplogic.snaps.transform.multijoin.JoinSorter.cleanup(JoinSorter.java:57), Reason: Null pointer exception occurred at: com.snaplogic.snaps.transform.multijoin.JoinSorter.cleanup(JoinSorter.java:57), Resolution: Please file a defect against the snap

Can you share a picture of the join configuration?

Hi, there it is.
thanks,

If you sort the inputs before providing them to the Join, and change the “Sorted Streams” setting to the appropriate Ascending/Descending, do you get the same behaviour?

Hello, working fine, thanks, I did not know we needed to sort instead of using non sorted results.
Thanks,