User Defined Detection

The User Defined method of duplicate detection allows you to set up Match Codes on any field in the database.  You can determine how far into the field you want to match.  You can detect duplicates on as many fields as you would like and you can determine the order in which the fields are checked.  You can also set up an A.K.A. Dictionary to allow for common matches like Bob to Robert or IBM to International Business Machines.  

 

Follow the steps below to use User Defined Duplicate Detection:

 

The User Defined Match Code Setup window will appear.

 

User Defined Match Code Setup Window

 

 

Step 1

Soundex will locate matches based on a unique algorithm and will compare data that sounds similar, such as, Carrie and Cary.

. To delete a line from the Match Code, click the Delete button .

. To save the Match Code that you created, click the Disk button .  

. To open an existing Match Code, click the Open button .

 

Priority Record

Setting the Priority Record allows you to specify which record you would like to keep when duplicates are found.  Here are the different options available.

 

Review Duplicates

 

Backup Duplicates

 

All Records

 

Auto Run