How to remove duplicate record from two different dataset

Hello,

I have two Datasets (monthly) with similar fields and I am trying to remove duplicate orders from Dataset2. Example in DataSet1 - I have JUN data in which order #50711 already counted but again in Dataset2 (JUL) this order comes again. so I wanted to remove this order from Dataset2. So please assist me to design a flow that removes any duplicate order.

Help

Accepted answers

Hi @Learner09 ,

you can use a Join tool. The R output anchor returns all July orders not in contained in June table:

I've attached a sample workflow. Let me know if it works for you.

Best,

Roland

DuplicateOrders.yxzp

All comments

Hi @Learner09 ,

you can use a Join tool. The R output anchor returns all July orders not in contained in June table:

I've attached a sample workflow. Let me know if it works for you.

Best,

Roland

DuplicateOrders.yxzp

@RolandSchubert Thanks, it works

RolandSchubert thanks very much, works like magic for 2 data sets contains more than 100k of rows in just a matter of seconds.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703