Knowledge Base
User:
Password:
|
Article ID | : |
KB131 |
Keyword Name | : |
Merge, Merging, Why Won't, Record, Duplicate, Conform |
Created | : |
February 08, 2013 |
Viewed | : |
14939 |
Why won't some of my records merge?
Duplicate records can occur in your database for several reasons:
- Data from multiple sources imported.
- Data imported from a single source that had not previously merged duplicate records.
- Adding new records without first checking to see if a record already existed.
- Minor variances in name or address for records added through the Trail Blazer iframes on your website.
Trail Blazer can merge records where the names and addresses match EXACTLY. See http://www.trailblz.com/kb/?action=view&kb=45&cat=1 for more information on merging.
If after running a merge by name and address you still have unmerged records, review the following items within the record:
- Addresses. Look to see if one says Street and the other says St. One says Avenue and the other says Ave. These differences will prevent a merge. You need to conform your addresses. This is done from the File Menu of the Address list.
- Middle Names. Are they different? If so, they won't merge automatically.
- Birthdates. Sometimes everything can be identical only to realize there are different birthdates for the individuals. It may be a Sr./Jr. situation or an error in the birthdays.
- SOS Voter Number - If the data came from a voter election board, it will contain a voter number. If these are different, the records will not merge.
duplicates
|