ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
1 Day Left! - The Alteryx Community will be temporarily unavailable for a few hours due to implementation of the new SSO experience starting tomorrow at 5pm MDT. Please plan accordingly. For more information, read the blog.

Alteryx Designer Discussions

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

Remove Duplicate Rows Completely

khadijahneddy
5 - Atom

Hi, greetings everyone!

 

Can someone help me on how to remove the duplicate rows (RecordID, Data and File) completely? Tried to use the unique tools but it didn't work out.

 

Capture.PNG

Thank you in advance for the help!

atcodedog05
17 - Castor

Hi @khadijahneddy 

 

Unique tool should have worked. Provided (RecordID, Data and File) are unique. Hope you have set the columns in unique tool

 

atcodedog05_0-1605857833165.png

 

Can you provide the data as excel so that we can take a look.

Qiu
17 - Castor

@khadijahneddy 
so you mean if any duplicated, remove them all?

1120-khadijahneddy.PNG

vizAlter
12 - Quasar

Hi @khadijahneddy —  "Unique" tool is made for your purpose and it considers the case sensitivity.

Hence, your fields do not have any Upper or Lower case in text kind of issue.

(And, to convert your text in Upper or Lower case you may use a "Data Cleansing" tool, then apply a "Unique" tool.)

 

If this assists please mark the answer "Solved", if not let me know!

grazitti_sapna
15 - Aurora
15 - Aurora

Hi @khadijahneddy,

 

Unique tool should have worked for your use case. If you are facing issues can you please share a sample dataset?

 

Sapna Gupta
Labels