Support 805.461.7300
Sales
Our Technology. Your Success.

Merge Fields from Duplicate Records Into One

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:
https://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 remove them you can “Pack” the database.

« Back to Commands

I can't believe how excellent your support is. The last disaster you rescued me from was one that a programmer had told me had no answer that he knew of. Well, you know more than him! I e mail ed you on a SATURDAY and you had the problem solved by Monday morning!
C.P., Houston, TX