Trail Blazer Knowledge Base

 

Home : General : Auto-Merging Duplicate Address Records

Knowledge Base







User:

Password:



Article ID: KB45
Keyword Name: Merge, Management, Duplicates, Combine, Combining, Address, Cleanup,dedupe,de-dupe
Created: February 15, 2017
Viewed: 19034

Auto-Merging Duplicate Address Records


Overview

This article will guide you through the process of automatically merging duplicate address records.  It’s recommended to first conform your address records to fix inconsistencies such as Street vs. St. prior to running the merge process.  Click this link to learn how to automatically conform address records.



Steps to Merge Duplicate Address Records

First navigate to the address search window.  Under the Application Menu follow Voter/Donor > Addresses.





Either build and run a query or simply click [Search] to load the entire list of addresses.  In this example the query is left blank and the entire address list is loaded.





After you click [Search] you will be presented with the record count and have the option of how many records you need to load.  Specify the amount or click the (All) radio button to load the entire list.  It’s recommended that you load all records when running both automated merge and conform processes.





Select the [File] drop-down on the search tool strip and click Merge Addresses…





Select the preferences you need to merge by in the Merge Addresses window -- The Merge Window will have different options depending on if you’re merging voters or address records. --





Click [OK] to run the Merge.


When the merge is complete you will be presented with the Merge results, click [OK].





Click [Search] on the search tool strip to refresh the address list.  You will notice that my address list list went from 98,927 records to 97,746 after the merge process.


The merge process may need to be run more than one time if there are multiple duplicates of a record.



Video Resources

Trail Blazer Campaign Services YouTube Chanel:

How to Manage Duplicates Link




 

Are you ready to learn more? Contact Us