Remove All Instances of Duplicates
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
- Labels:
- Data Investigation
- Datasets
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here is how you can do it. Use summarize tool to get count and filter count!=1
Workflow:
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Wow, that's an interesting method @jdunkerley79 🙂
Will definitely take it for reference 😁
