Combine Duplicates Tool

The Combine Duplicates page allows you to view potential duplicates in your database using various search criteria. You can then determine whether you want to combine them, as well as customizing what data is merged, or determining if the two records listed are not duplicates.

Under the Tools tab, select Combine Duplicates. On the resulting page, note the following buttons at the bottom as your search criteria:

Type: This determines which record type to search through when searching for potential duplicates. The options are Individuals, Organizations, or All.

Search Method: This allows you to conduct a wide range of potential duplicates or a more honed in method, such as Exact Name Only or Exact Name and Address, Line 1.

Exclude: If you previously marked two potential records as not a duplicate match, you can choose to exclude them in the next search or include them again in the search results.

Download Duplicates List: Clicking this button allows you to download the duplicates search results in an Excel spreadsheet.

Combine All: This option combines all results on the screen. Caution should be used if you have a large list of potential duplicates, as some may not be duplicates and shouldn’t be combined.

After you’ve determined your search criteria and you have the results on the screen, you have a few options to the right of each grouping:

Combine: If you’ve determined the two records are in fact duplicates, clicking this button will combine them into one record.

*Note there is a magnifying glass icon next to the blue Combine button. Hovering your mouse over this will provide any information marked as Primary in the records, whether it’s the Phone, Mailing Address, or Reportable Address.

Not A Duplicate: This will remove the two records from the search results and mark them as not duplicates in future searches. They can, however, be added back into the results by using the option to include them via the Exclude button at the bottom of the screen.

Customize: When you click this button, a small window appears. Here you can both add missing details to the record in question, as well as determine which PhoneMailing Address, and Reportable Address should be marked as Primary when combining the records. Clicking the Combine button will complete the record combining process.

Related Information:

Click here to learn more about combining duplicates from the Individual/Organization search screen.