11-20-2019 02:31 AM
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,
Solved! Go to Solution.
11-21-2019 03:15 AM
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?
11-21-2019 03:15 AM
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?
11-21-2019 04:35 AM
Hello, working fine, thanks, I did not know we needed to sort instead of using non sorted results.
Thanks,