Join tool matching Duplicate transactions as well.

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

WF Query.yxmd

Data Investigation

Accepted answers

JosephSerpis

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.

WF Query.yxmd

All comments

JosephSerpis

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.

WF Query.yxmd

Srawat

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

binu_acs

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

WF Query.yxmd

Srawat

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703