COUNTIF equivalent? Need to identify duplicates.

[skeen503979]

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?

[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 · Accepted solution]

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/

[skeen503979]

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