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.

Duplicates/Join

furlonla
8 - Asteroid

Hi, 

 

I am trying to identify all the duplicates from my dataset (see photo), I want the first two Nulls to read duplicates. What is the most straightforward way to do this?

 

Any help would be much appreciated!

 

Thanks,

Laura

 
 

 

 

 

 
 

 

 

 

1 REPLY 1
afv2688
16 - Nebula
16 - Nebula

Hello @furlonla ,

 

This may be the easiest way to find the duplicates with their originals. If you use only the unique tool you wouldn't be able to have all the values on the same output.

 

Untitled.png

Hope it helps 🙂

 

Regards

Labels