Easiest way to delete duplicates
I have a table that may contain duplicates. What is the easiest way to find and delete all but one of them?
Forum Discussion
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]
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]