Delete Duplicate Records

Save your company’s time, money, and reputation.

Successfully cleaning up any type of company database involves removing duplicates. A common problem, this often happens when reviewing or combining one or more mailing lists/databases.

Without the right tools, removing duplicates can often be time-consuming and cause even more errors!

One of the critical pieces of eliminating duplicates is survivorship. If you have duplicate records, which one should stay (survive) and which one should go?

Let’s take the example below.

 

In this example we have two duplicate records. Each has some slightly different data in the notes field. You may prefer to keep all the records, but oftentimes a single master record must be chosen to maintain data quality. slightly different data in the notes field. You may prefer to keep all records, but often times a single master record must be chosen to maintain data quality.

DataMatch allows for customized settings for which merged data should survive.

With DataMatch, yo u can choose which record survives by choosing What field to merge on and in what order. In this case, it would be the customer number, in ascending or descending order. If in ascending order, the first customer number would hold priority (1005643). If in descending order, it would be customer number 1106789. You can always change which record is a master manually in DataMatch.

Unfortunately, normal duplicate removal software routines can delete vital business data.

Now, what if you want to keep both pieces of information in the same master record? DataMatch has this capability!

The best solution would be to keep all data that is different in a new field. The result would be this:

 

Note the alternate information is captured in a new field. The benefit is a single master record, with no vital data loss. (Old customer number kept for referencing, and critical customer comments, like interest in a new product, kept)

DataMatch is our flagship product to delete duplicate records.

 

Don’t put your company’s reputation at risk. Try a free trial of DataMatch today!

 

Note DataMatch never deletes any information from the source files , all information is kept temporarily in memory where you can test different duplicate removal settings without consequence. Although you can overwrite your original source files if you choose.