Remove All Instances of Duplicates

[Tim_Sullivan]

I have been trying to find a way to remove all instances of duplicate values. I know the unique tool will identify duplicate values but it leaves the first instance. How would I go about doing this?

[atcodedog05]

Hi @Tim_Sullivan 

Here is how you can do it. Use summarize tool to get count and filter count!=1

Workflow:

Hope this helps : )

[CharlieS]

Hi @Tim_Sullivan 

I suggest using a Summarize tool to count the record of each value, Filter to records where [Count]=1, and Join those records back to the original. The joined records would be only values that occur once. 

Check out the attached workflow and let me know if that helps. 

[jdunkerley79 · Accepted solution]

Hi,

There are a few different ways.

One different approach to @atcodedog05 is to add a Join tool after the Unique tool. Joining on the unique fields

You can then just take the Left output and it will be the uniques.

Hope it helps

[atcodedog05]

Wow, that's an interesting method @jdunkerley79 🙂

Will definitely take it for reference 😁