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?
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!