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