NOTE: Data quality rules are not transformation steps. They assess the current state of the sampled data in the Transformer page.
NOTE: As As you apply transformation steps to the data, the state of your data quality rules is automatically updated to reflect the changes. If you delete columns or other elements referenced in the data quality rules, errors are generated in the Transformer page.
- To begin, click Add rule.
- Select a rule to create. For more information on the available rules, see Data Quality Rules Reference.
May be missing: Some rule types support the May be missing checkbox. When it is enabled, the Data Quality rule allows missing values to be acceptable for a specified column.
NOTE: The May be missing rule parameter is not applicable to Not Null, Not Missing, Not Equal, Not In Set and Formula.
- In preview, the rows that pass the rule are highlighted in green, while the rows that fail the rule are in red.
- To add the rule to your set, click Add.