Use a duplicate check rule to check if the data doesn't already exist in the table.
Name | Responsible | Description |
---|---|---|
Set up duplicate check |
Data quality administrator |
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. |
Set up duplicate check rule |
Data quality administrator |
Use a duplicate check rule to check if the data doesn't already exist in the table. Before you can set up a duplicate check rule, set up the duplicate check to be applied. A duplicate check defines which combination of table fields is checked on duplicate values. So, the combination of field values must be unique in the table. |
Set up duplicate check rule conditions |
Data quality administrator |
For each duplicate check rule, you can set up conditions. The duplicate check rule is only applied if the conditions are met. To define a duplicate check rule condition, you use a query. The duplicate check rule is applied only to the records that are found by the query. You can use these types of queries:
|