Support 805.461.7300
Sales
Our Technology. Your Success.

Merge Data from Duplicate Records into 1 record and 1 Field

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 into 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**

« Back to Commands

I am especially motivated to take time to draw attention to Vince. In two instances, we potentially faced loss of product – significant loss, but thanks to everyone’s efforts, most notably Vince’s, we ended up with minor re-work and zero loss of stock. He’s patient and thorough, knowledgeable and resourceful. And he’s patient – A Big Plus when dealing with me. Long story short, the guy was able to not only produce a solution, but to prove to me the veracity of it. I hung up the phone saving thousands of dollars in catalog stock, not lost but salvaged, and my department had to spend just a wee bit of time on job re-work (which I was happy to do, all things considered). But I also hung up with a peculiar urge to write about Vince, incongruent as that may be since I rarely am moved to write letters of this sort. So… In a time of crisis, Vince was a terrific asset and ally. If I were his boss, I’d attempt a merit raise authorization, he was that exceptional.
H.D., Shawnee Mission, KS