I have two datasets
Here when I match both datasets based on 'COL1' AND 'col1'
i will get three rows
My expectation is join does not work for value 1 because it has two matches.
Please suggest solution where I can do this using one single node and not using multiple nodes(x-ref+remove duplicates) so that I can get output, that has unique match only and ignores not two or more matches.
Please sign in to leave a comment.