Forum Discussion

eric_sou's avatar
eric_sou
New Contributor III
6 years ago
Solved

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,

pattern
  • cstewart's avatar
    cstewart
    6 years ago

    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?

6 Replies

  • cstewart's avatar
    cstewart
    Former Employee
    6 years ago

    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.

    • eric_sou's avatar
      eric_sou
      New Contributor III
      6 years ago

      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

      • cstewart's avatar
        cstewart
        Former Employee
        6 years ago

        Can you share a picture of the join configuration?

  • cstewart's avatar
    cstewart
    Former Employee
    6 years ago

    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?

    • eric_sou's avatar
      eric_sou
      New Contributor III
      6 years ago

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