QUESTION:
I am merging records in Single Table Dedupe and many are failing with the following message regarding duplicate value found, how can I resolve?
- "Merge Call Failure",,,,,,,"Msg:duplicate value found: ImportID__c duplicates value on record with id: XXXXXXXXXXXXXXX
ANSWER:
That error happens when attempting to update a blank on a master record for a unique field from the non-master record. The update where empty action happens prior to the merge which makes the system think that the value is not unique and throws the error.
To resolve you will need to select the record where that field is populated as the master record, that way it is not trying to do an "update where empty".