COUNTIF equivalent? Need to identify 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 a large Excel file that contains duplicate data. I want to identify what the duplicates are. In Excel I would normally just do a formula to count the number of times that particular device ID is listed using a Countif formula, but my data set is over 600k rows.
In Alteryx:
How can I create a column to identify duplicates?
Solved! Go to Solution.
- Labels:
- Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can use Summarize tool where you can Group By the data field and then Count the same data field. It will basically give you two columns one with Device ID and other with count of the device ID you have in your dataset. I hope this is what you were looking for. Let me know if otherwise.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @skeen503979
I would recommend a macro called Only Unique. It can be downloaded as part of the CReW macro pack. This tool will allow you to select the fields you want to check for duplicates in then output all of the unique records through the U stream and all duplicates out the D stream.
Download here: http://www.chaosreignswithin.com/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @Kenda! Intriguing toolset. Can't wait to explore: http://www.chaosreignswithin.com/p/macros.html
