Forum Discussion

patan's avatar
patan
New Contributor III
5 years ago
Solved

Join with Merge functionality

I am using the Join snap with merge to take the output from two different pipeline execute snaps invoked from the same parent pipeline. Parent pipeline as shown below: I am passing the same ...
  • vmaitra1's avatar
    vmaitra1
    5 years ago

    Hi Patan,

    You can try left outer join with $original.path as join condition for both left and right paths. Merge will simply combine the left and right docs and if there is a difference in count then it will join incorrectly. With left outer join all the output docs for create will be present with the corresponding fetch results.

    Thanks, V

vmaitra1's avatar
vmaitra1
New Contributor
5 years ago

Hi Patan,

You can try left outer join with $original.path as join condition for both left and right paths. Merge will simply combine the left and right docs and if there is a difference in count then it will join incorrectly. With left outer join all the output docs for create will be present with the corresponding fetch results.

Thanks, V