Identifying unique records

johnrexrima_19

Hi,

I am trying to identify records with duplicate within the same column. I initially used summarize tool but I don't have possible data to group them as the data from other columns also have duplicates. What other tools can I use instead?

Thank you.

echuong1

Are you trying to identify unique values and get the first instance if there are duplicates, or are you trying to identify only unique values and pull out any instance of two or more?

If it's the first option, you can use a standard unique tool. Essentially it will grab any row that has unique values for any unique combination of the fields selected. If there are duplicates it will grab the first instance. Any subsequent instance will come out of the D output.

If you want only unique values, you can use the Only Unique Crew Macro. This will pull out any combination of values that is only in the data once, as well as any combinations that are in the data multiple times.  

Crew macros here: http://www.chaosreignswithin.com/p/macros.html

See attached for an example.

New Workflow18.yxmd