1. Data Management
  2. Data Quality Studio on Dataverse
  3. Setting up Data quality studio on Dataverse

Set up data pattern rule

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 flow explains how to set up a rule of type Data pattern.


Data quality administrator Data quality administrator Start Start Desired data  pattern exists? Desired data  pattern exists? Set up data pattern Set up data pattern You can use a data pattern rule on a Dataverse table to validate if a field value matches a defined pattern. To set up a data pattern rule, first set up the data pattern to be applied. Define the data pattern, using a regular expression. You can, for example, set up data patterns to validate: Email addresses Website URLs VAT numbers For more information on regular expressions, refer to Regular expression. Procedure 1. Sign in to Data quality studio on Dataverse. 2. In the Site map, click Data Patterns. 3. Click New. 4. In the Name field, enter a descriptive name for the data pattern. 5. In the Data Pattern field, enter a regular expression that defines the data pattern. 6. In the Error Message field, enter the message that is shown when validation fails to match the data pattern. 7. In the Owner field, if desired, you can make changes. 8. Subtask: Test data pattern. 9. In the test Cases section, click New Test Case. 10. In the Input field, enter a test value. 11. In the Expected Result field, indicate if you expect the input value to fail or past the test. 12. Click Save & Close. Note: The test is automatically done. In the Test Cases section, you can compare the actual result with the expected result. Set up data pattern rule Set up data pattern rule 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. 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. 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. In the Owner field, if desired, you can make changes. 9. Click Save. 10. Subtask: Set conditions. 11. Click the Conditions tab. 12. Click New Condition. 13. In the Column field, enter or select the field on which the condition is based. 14. In the Equality field, select the desired option. 15. In the Value field, enter the field value on which the condition is based. 16. Click Save & Close. End End No Yes

Activities

Name Responsible Description

Set up data pattern

Data quality administrator

You can use a data pattern rule on a Dataverse table to validate if a field value matches a defined pattern.

To set up a data pattern rule, first set up the data pattern to be applied. Define the data pattern, using a regular expression.

You can, for example, set up data patterns to validate:

  • Email addresses
  • Website URLs
  • VAT numbers

For more information on regular expressions, refer to Regular expression.

Set up data pattern rule

Data quality administrator

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.

Provide feedback