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.
Solved! Go to 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
@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.