Skip to main content
Question

Easiest way to delete duplicates

  • March 31, 2018
  • 0 replies
  • 58 views
I have a table that may contain duplicates.  What is the easiest way to find and delete all but one of them?
    This topic has been closed for replies.

    I'm sure that there is a script solution, but for a native solution I would set up a table with and create text key field.

    Then in your details table where the potential dups are, create a formula text field which concatenates the fields which define uniqueness.   I'm, not sure from your post if that is one field like an email address or the combination of a few fields. 

    Like List("-", [first name],[last name], [Phone])

    Then make a summary field report on that field and then copy the report to the Uniquer table you just created.

    Then make a relationship between the two tables and make a summary minimum field of the [Record ID#].  Then look that up down to the  details table.

    The non dups will be the detail records where the [Record ID#] <> Minimum Record ID# for unique value]
    Terms & ConditionsAccessibility statement