Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to remove duplicate record from two different dataset

Learner09
8 - Asteroid

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.

3 REPLIES 3
RolandSchubert
16 - Nebula
16 - Nebula

Hi @Learner09 ,

 

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

24-07-_2020_09-41-40.png

 

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

 

Best,

 

Roland

Learner09
8 - Asteroid

@RolandSchubert   Thanks, it works

Saad_Elmisery
5 - Atom

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

Labels