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.

Remove Duplicate Rows Completely

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.



Thank you in advance for the help!

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




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

17 - Castor

so you mean if any duplicated, remove them all?


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!

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