Alteryx: How can I quickly remove all duplicates from a field?
Question ID: 109622

I have a field of numbers with the following values:

1, 1, 2, 3, 4, 4, 4, 5

I would like to generate an output which only contains the numbers which are NOT duplicated. My ideal output would be:

2, 3, 5

When I use the Unique tool I get 1, 2, 3, 4, 5 on the U anchor and 1, 4, 4 on the D anchor. Is there a quick way to produce the output I am looking for?



Marked as spam
Posted by (Questions: 17, Answers: 0)
Asked on June 17, 2020 11:53 am
Answers (1)
Private answer

There is a tool in the CReW Macros (downloadable here: that does just this. Once you get these macros you will find a tool called 'Only Unique'  (the icon is nearly identical to unique, it is just a fatter snowflake) which does exactly this. Simply select the field you would like unique values on and the U anchor will produce your desired results.

In your case, the U anchor would show: 2, 3, 5 and the D anchor would show: 1, 1, 4, 4, 4.


I hope that helps!

Marked as spam
Posted by (Questions: 0, Answers: 17)
Answered on June 17, 2020 2:10 pm

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

Scroll to Top