Alteryx: How can I quickly remove all duplicates from a field?
| ♥ 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 |
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 Captain Tester (Questions: 0, Answers: 17) Answered on June 17, 2020 2:10 pm
|