Join tool matching Duplicate transactions as well.

[Srawat]

Hi,

I am trying to match left one transaction with other side transaction, however due to left side duplicate transactions it's matching both the left transactions with right transaction .Can we make a rule so that only one transaction came to match instead other same transactions.

I have attached a WF pls refer and advise.

Why this match.

Thanks

[JosephSerpis · Accepted solution]

Hi @Srawat typically in this scenerio you would have to remove the duplicates in your data so don't get what called carteisan joins. One way is to add a unique tool which I've done to your workflow.

[Srawat]

The solution looks good. however is there any other way available ?

[binuacs]

@Srawat If you can add a unique field like Ref in both the table you will get the expected result

[Srawat]

Thanks, however unique field is possible for few transactions and in high volume data it will be difficult.