Foundational DQ - Unique Values Rule

The "UNIQUE VALUES" rule evaluates whether the count of unique values within a particular dataset falls within an acceptable range or matches a specified number.

For instance, if there are 100 ship-from locations expected, the rule anticipates the count of unique locations to range between 95 and 100. An occurrence exceeding 100 suggests an error, typically due to duplicated or erroneous entries. Conversely, if the count falls below 95, it signifies a potential error, often attributable to missing or incomplete data.

By applying this rule, data analysts can ensure that the number of unique values conforms to expectations, thereby upholding data quality and reliability.

For further information about the rule detail page including scope, threshold, notifications, etc., please see the detailed article Rule Detail page.

Detailed Steps:

Step 1:

Log in to DvSum and proceed to the Data Dictionary tab and select the relevant Data source and Table Name.

Step 2: Select the table name then select the Data Quality tab and choose Available Rules.

Step 3: Select the "⊕ Add Rule" button, then choose the "Foundational DQ" category. From the list of options, click on "Value Range".

Step 4: Basic Input

In the Rule Wizard's Basic Input section, you need to fill in the Rule Description, Column Name, corresponding to the table in which you want to search for Unique records.

Step 5: Validate

After saving the rule, you'll see its definition. Click "Run" to execute and test the rule.

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk