Merge Data from Duplicate Records into 1 record and 1 Field.

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
Dave
Site Admin
Posts: 620
Joined: Wed Sep 20, 2006 3:20 pm

Merge Data from Duplicate Records into 1 record and 1 Field.

Post by Dave » Wed Mar 27, 2013 12:02 pm

This command will combine information from up to 3 different fields and 30 duplicate records into one record.

 Download the command file to your system.
 Extract the “Merge Dup Information Into A Single Field 30 Max.txt” into the AccuZIP6 5.0\Commands Folder.
 Extract the “merge_dup_any30.FXP” directly in to the AccuZIP6 5.0 folder.
 Open the database that you would like to run the command on.
 Run the duplicate search as normal, MAKE SURE TO SELECT “Backup Duplicates” in that screen.
 Run the command from the Edit|Command option. This command will combine up to 30 matching records into one field.
 In the command you can combine up to 3 fields, simply list the fields in the command.


Example:
**1st Field**
COM_FIELD="
FIRST"
=MERGE_DUP_ANY30()
**1st Field**

Post Reply