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.
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:
|
  | 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 |
  |