cancel
Showing results for 
Search instead for 
Did you mean: 

Join Merge on all rows

eric_sou
New Contributor III

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,

1 ACCEPTED SOLUTION

cstewart
Former Employee

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?

View solution in original post

6 REPLIES 6

cstewart
Former Employee

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
New Contributor III

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