Remove Dupes with checks on secondary fields first

Vote count:

0

I have a table with a field (Name) I'd like to create a unique index on, however it seems there are existing duplicates. I dont' want to just get rid of dupes since some might have information in other fields that I need. Essentially I have:

• ID


• ParentID


• Name


• Code


• RelatedID

So Goal 1 is I want to keep the record that has values in the secondary fields other then ID and Name. In most cases this will be one of the dupes only.

Goal 2 is in case two identical Names both have values but in different fields I want to 'merge' those since it is remotely possible one duplicate will have values in one key field and one in the other.

Finally Goal 3 is in the case that two names both have values in a key field I'd probably want to manually review those first.

It seems to me my first step as I read this would be Goal 3; manually review duplicates where Name Field is identical, and more then one record has a non-Null/non-empty value in a key field.

Once I address this the goal would be to 'mere' the remaining records i.e keep one record with Name and any non-null/non-empty key fields from the others.

Any thoughts much appreciated.

asked 1 min ago

Mark H

36