You can use rules to check if data, that is entered in a Dataverse table, is in line with the defined standards.
Use a data pattern rule to validate if a field value matches a defined pattern.

Before you can set up a data pattern rule, set up the data pattern to be applied.

This topic explains how to set up a rule of type Data pattern.


Standard procedure

1. Sign in to Data quality studio on Dataverse.
2. In the Site map, click Configurations.
3. Click New.
4. In the Table field, enter or select the table to which the validation rule is applied.
5. Define the column to which the data pattern validation rule is applied. If you enter or change a value in this column, on Save, the data pattern is validation is done.
  In the Column field, enter or select the desired column.
6. In the Validation Type field, select 'Data Pattern'.
7. In the Pattern field, enter or select the data pattern to be applied.
8. When you create a validation rule, by default, your user account is assigned as the owner.

You can assign another user account as owner.

  In the Owner field, if desired, you can make changes.
9. Click Save.
10. Subtask: Set conditions.
  10.1 It can be that the data pattern validation applies only to specific records in the table. Use conditions to indicate to which records the validation applies.
  Click the Conditions tab.
  10.2 Click New Condition.
  10.3 In the Column field, enter or select the field on which the condition is based.
  10.4

Indicate if the condition includes or excludes records:

  • Equal: The validation rule applies only to records with the defined condition value.
  • Not Equal: The validation rule applies to all records except the ones with the defined condition value.
  In the Equality field, select the desired option.
  10.5 In the Value field, enter the field value on which the condition is based.
  10.6 Click Save & Close.
Related to Notes

Set up data pattern rule

 

Provide feedback