How to remove duplicate record from two different dataset

[Learner09]

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.

[RolandSchubert · Accepted solution]

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

[Learner09]

@RolandSchubert   Thanks, it works

[Saad_Elmisery]

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