Locating Duplicates

  • 1
  • 2
  • Question
  • Updated 4 years ago
  • Answered
After selecting "Values in the field must be unique" and "Check existing entries for duplicate values." in the Field Properties, I get an error warning that the existing values in the field are not unique.

How do I locate records where there are duplicates in a particular field?
Photo of Karen

Karen

  • 222 Points 100 badge 2x thumb

Posted 6 years ago

  • 1
  • 2
Photo of Mark_Shnier

Mark_Shnier

  • 700 Points 500 badge 2x thumb
The way we all have to do it is to make a report of Type Summary, and group by that unique field. Then click the column heading that has the Count of record. That will sort it lowest to highest, so click again and it will resort from highest duplicate count to lowest. Save the report, at a personal report.

Then just keep drilling into the 2's and 3'3 at the top of the report and fixing the data until they are all edited so there are only 1's as you come back to the saved report.
Photo of Karen

Karen

  • 222 Points 100 badge 2x thumb
Thanks Mark. I ended up creating a report of all records and included that column, then exported it to a spreadsheet and let Excel show me which were the duplcates. :)
Would be nice to be able to add that to the Advanced Search funcion....
Photo of Taylor

Taylor

  • 52 Points
Related question: when I add a 'group-by column' option to my summary table I'm no longer able to sort from high to low. Am I missing something? Alternatively, is it possible to filter the report to only show summary values >1?