To set up a duplicate check rule, a duplicate check is required. If the desired duplicate check does not exist, set up a new duplicate check.

For each 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.


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. Define the table of which you want to check fields on duplicate values.
  In the Table name field, enter or select a value.
6. Sub-task: Select the fields to be checked on duplicate values.
  6.1 In the Fields section, click Add.
  6.2 In the Available list, find and select the desired fields.
  6.3 Click -> (Add) to add the fields to the Selected list.
  6.4 Click OK.
7. Sub-task: Make the duplicate check active.
  7.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.

8. Close the page.
Related to Notes

Set up duplicate check rules

 

Provide feedback