Merged Duplicates

Under Duplicate management, in the Merged duplicates list, you see the duplicate records you chose to merge and the current status of the merge.

  • Merge complete: The merge was completed successfully.

  • Merge in progress: The merge is currently running but has not been completed.

  • Merge pending: The merge is scheduled to run but has not yet started.

  • Error while merging: The merge was attempted but could not be completed.

To narrow the focus of the list, you can filter by merge status or date.

If a merge has a status of Error while merging, there could have been a temporary connection error during the merge. Select Retry merge from the menu to attempt the merge again.

Note: When duplicates are merged, the source records are marked as inactive but not deleted.

When you merge two duplicate records, they appear in the Merged duplicates list under Duplicate management. After the merge, source records are marked as inactive but not deleted. To clean up your data, you can delete successfully merged source records you no longer need.

  1. In Tools, Data health, select the Possible duplicates total.

  2. Under Duplicate management, in the Merged duplicates list, select Create list of source records.

  3. Under New list, select Save, Save in database view as a static query.

  4. Enter a name for the static query. You may also enter a description and select the security options for the query. Select Save.

  5. In the database view, globally delete the merged source records.

    • In Admin, select Globally Delete Records.

    • Under Record type, select Constituents.

    • Select Include, Selected Constituents

    • Under Query type, select Constituent.

    • Select Find Now and choose your new static query from the list. Select Open.

    • Under What do you want to do? select Delete records.

    • Select Delete Now and confirm.

Note: For more information about global delete, see the Global Add, Delete, and Change Guide.