ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
解決済み

How to remove duplicates in a particular column

AKPWZ
アステロイド

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件の返信3
ShankerV
キャスター

Hi @AKPWZ 

 

Please use the Unique tool.

 

ShankerV
キャスター

Hi @AKPWZ 

 

Sample use case for your scenario.

 

ShankerV_0-1678957162791.png

 

ShankerV_1-1678957181896.png

 

Many thanks

Shanker V

 

 

AKPWZ
アステロイド

Thank you @ShankerV exactly what I was looking for. 

ラベル
トップのソリューション投稿者