Purpose
The pattern serves to check wheter a given key is unique. The result lists all data points that violate uniqueness.
Pattern
For each key, its number of occurrences is counted and all keys with counts greater than one are reported.
Parameters
- TBL: Defines the name of the table containing the data.
- KEY: Specifies the primary key or unique key of the table. This may also be a comma-separated list of attributes (compound key).
Usage
In this use case, we apply the UNI pattern to check whether the combination of first name and last name uniquely identifies a client in our database.
Dataset
Parameter
- TBL = [TBL-DQ.UNI$]
- KEY = FIRST_NAME, LAST_NAME
Statement
Output
