Easiest way to delete duplicates

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • Answered
I have a table that may contain duplicates.  What is the easiest way to find and delete all but one of them?
Photo of Robert

Robert

  • 180 Points 100 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,036 Points 50k badge 2x thumb
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]