Creating a data quality rule in basic mode
About this task
In this example, you are working in a e-commerce company. You noticed some orders have not been shipped yet and you want to know why.
The purpose is to create two rules that will prevent any shipping delay. To do that, you need to check that the country is correct and the Tax Identification Number (TIN) is filled in.
Two data quality rules are used in this example:
- One validates that: If the order status is In process, then the country is not empty and is spelled correctly according to the country semantic type.
- The other one validates: If the customer is identified as a company, then the TIN is filled in.
Here is a sample of the dataset: