Anyone have a technique that allows you to quickly identify duplicate records in a table? My use case is the most basic: I simply want to find duplicate records in a table based on the primary field.
I used the "group" feature and then scanned the table looking for duplicates, but it was slow and not as accurate as I would like.
Is there a way to filter for duplicates or to Spotlight duplicates?
I have seen reference to a planned feature that would remove duplicates, but I just want to see them first to assess which record I want to keep.
Thanks,