1. Data Management
  2. Data Quality Studio
  3. Activities

Set up duplicate check - Basic matching
Application task

Use a basic duplicate check to ensure that no (almost) similar records exist in a table.

To set up a duplicate check rule you can use a duplicate check of type Basic matching. If the desired Basic matching duplicate check does not exist, set up a new Basic matching duplicate check.

For each Basic matching duplicate check, define which combination of table fields is checked on duplicate values. So, the combination of field values must be unique in the table. Only one record can have this combination of field values.


Standard procedure

1. Click Data quality management.
2. Click Duplicate checks.
3. Click New.
4. In the Duplicate check name field, type a value.
5. In the Duplicate check type field, select 'Basic matching'.
6. Define the table that you want to check on duplicate records.
  In the Table name field, enter or select a value.
7. Sub-task: Select the fields to be checked on duplicate values.
  7.1 In the Fields section, click Add.
  7.2 In the Available list, find and select the desired fields.
  7.3 Click -> (Add) to add the fields to the Selected list.
  7.4 Click OK.
8. Sub-task: Select the fields that can be merged for a duplicate record.
  8.1 In the Merge fields section, click Add.
  8.2 On the dialog, in the list, find and select the desired fields.
  8.3 Click Add (->).
  8.4 Click OK.
9. Sub-task: Activate the duplicate check.
  9.1 If the duplicate check setup is finished, you can make it available for selection on the duplicate check rules.
  Select Yes in the Active field.
 

Note:

  • If active, you cannot edit the duplicate check.
  • If active and used in an active data quality policy version, you cannot make the duplicate check inactive.
10. Close the page.
Related to Notes

Set up duplicate check

 		 

Provide feedback