COUNTIF equivalent? Need to identify duplicates.

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?

Help

Accepted answers

Kenda

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/

All comments

agrawaluk

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.

Kenda

Hey @skeen503979

Download here: http://www.chaosreignswithin.com/

skeen503979

Thanks @Kenda! Intriguing toolset. Can't wait to explore: http://www.chaosreignswithin.com/p/macros.html

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335