Start Free Trial

Alteryx Designer Desktop Discussions

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

How to remove duplicates in a particular column

AKPWZ
8 - Asteroid

I want to remove duplicates from a column and keep only one record (any one out of n duplicates), I can use summarize tool but that can not give me the desire output alone. 


Attaching the screenshot with a sample data. 
Please help me to resolve this. Thank you!

 

AKPWZ_0-1678956780392.png

 

3 REPLIES 3
ShankerV
17 - Castor

Hi @AKPWZ 

 

Please use the Unique tool.

 

ShankerV
17 - Castor

Hi @AKPWZ 

 

Sample use case for your scenario.

 

ShankerV_0-1678957162791.png

 

ShankerV_1-1678957181896.png

 

Many thanks

Shanker V

 

 

AKPWZ
8 - Asteroid

Thank you @ShankerV exactly what I was looking for. 

Labels
Top Solution Authors