Applying a data quality rule to a field
- Cloud API Services Platform
- Cloud Big Data
- Cloud Big Data Platform
- Cloud Data Fabric
- Cloud Data Integration
- Cloud Data Management Platform
- Cloud Pipeline Designer Standard Edition
- Data Fabric
Before you begin
About this task
Procedure
-
Log in as a dataset manager or administrator with the Rules -
View permission.
To have the Rules - View permission, the roles Rule - Manager or Rule - Viewer must be assigned to you.
- Go to the Datasets tab and open a dataset.
-
Go to the Sample view and select a field.
In this example, select delivery_country.
-
In the right panel, click Add a rule.
- Select the rule Country value check and click Next.
-
Associate the variables with the fields:
- order_status with order_status
- country with delivery_country
When the variable and field names are similar or identical, the variables are automatically associated to the fields. If you want to change the field, click it and select another one from the drop-down list.
-
Click Validate. You are back to the
Sample view.
The rule is grayed out in the right panel because it is not applied yet.
-
As you must apply another rule to another field, you have two choices:
- You can apply the rule right now by clicking Apply 1
change above the right panel.
- You can configure the second rule and apply both rules at the same time.
Information noteImportant: When you make several changes, they will be all applied at the same time. You cannot choose the changes you want to apply. Clicking Reset cancels all changes you have not applied yet.In this example, the rules will be applied at the same time.
- You can apply the rule right now by clicking Apply 1
change above the right panel.
- Select the field customer_tin and, in the right panel, click Add a rule.
- Select the rule Customer Tax ID check and click Next.
-
Associate the variables with the fields:
- customer_segment with customer_segment
-
customer_tin with customer_tin
-
Click Validate. You are back to the
Sample view.
The rule is grayed out in the right panel because it is not applied yet.
-
Click Apply 2 changes above the right panel.
Applying the changes can take a few minutes depending on the dataset.
The rules are applied to the fields and you can see the invalid, non-applicable, and valid values.- Above the dataset
- In the column header
For more information, see Analyzing the quality of a field.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!