Merge Fields from Duplicate Records Into One

Build your list of AccuZIP6 commands by requesting commands and sharing commands with other users

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
User avatar
Terry
Site Admin
Posts: 1983
Joined: Wed Sep 20, 2006 3:45 pm

Merge Fields from Duplicate Records Into One

Post by Terry » Fri Mar 08, 2013 10:28 am

If you have duplicate records in a file that you wish to merge together into a single record, this command and process will do that. This command has a limitation of 5 duplicates per entry, however.

For example, if you had a records in your database where the primary information matched, but there were accounts or other columns that might have different values, this command will create a single record with multiple account fields (account, account1, account2, etc) with each of the values in them.

First, download the file linked below:
http://www.accuzip.com/files/forum/mergedupeinfo.zip

- Download the file linked above to your system.
- Extract the “merge_dup_any.FXP” to the “C:\Program Files (x86)\AccuZIP6 5.0” folder.
- Extract the “Merge Dupe Info Mail-it Plus.txt” to the “C:\Program Files (x86)\AccuZIP6 5.0\Commands” folder.
- Open the database that you would like to run the command on.
- Run the duplicate search based on how you would like to compare the records,( e.g: Person, Address or household)
Note: MAKE SURE TO HAVE BACKUP DUPLICATES SELETED
- Update the database with the duplicates.
- Run the command. Currently, the command is set to merge 3 fields. You can remove any of the lines or add to them if you need additional fields merged.
- When the command is complete, you will see the additional fields at the end of the record with the merged data in them.

The records will be left “Flagged for deletion” in the original database. If you would like to permanently like to remove them you can “Pack” the database.

Post Reply