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

Question ID: 109622
2
0

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?

 

Thanks.

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

There is a tool in the CReW Macros (downloadable here: http://www.chaosreignswithin.com/p/macros.html) 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: 7)
Answered on June 17, 2020 2:10 pm