Discussions

Expand all | Collapse all

Easiest way to delete duplicates

  • 1.  Easiest way to delete duplicates

    Posted 03-31-2018 13:09
    I have a table that may contain duplicates.  What is the easiest way to find and delete all but one of them?


  • 2.  RE: Easiest way to delete duplicates

    Posted 03-31-2018 16:22
    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]