1. Data Management
  2. Data Quality Studio
  3. Activities

Set up validation rule message
Application task

You can define a message that is shown if the validation rule is not met.

If no validation rule message is defined, the default message is shown if the validation is not met.
In case of a data pattern validation, the applicable data pattern can also have a message defined. In this case, the message priority is:
  1. If a validation rule message is defined, this message is shown.
  2. If no validation rule message is defined, the data pattern message is shown.
  3. If no data pattern message is defined, the default message is shown.
You can also enter a description of the validation rule.
You can translate both the validation message and the validation rule description.


Standard procedure

1. Click Data quality management.
2. On the Data quality policies tab, in the list, click the link of the desired data quality policy.
3. Click Edit.
 

Note: If you want to edit another data quality policy version than the currently shown version, first select the desired version. To do so, on the Action Pane, on the Version tab, click Versions. On the dialog, select the desired version and click OK.
4. On the Validation rules tab, in the list, find and select the desired validation rule.
5. Click the Messages tab.
6.

Define the validation message that is shown if the validation rule is not met.

In the validation message, you can use these tags:

  • Field name: When the validation message is shown, the [Field name] tag is replaced with the name of the validated field.
  • Field value: When the validation message is shown, the [Field value] tag is replaced with the value that is entered in the validated field.
  In the Validation message field, type a value.
7. You can enter a description of the validation rule.
  In the Rule description field, type a value.
8. Sub-task: Translate validation message and description.
  8.1 You can translate both the validation message and the validation rule description into several languages.
  Click Translations.
  8.2 Click Add to open the drop dialog.
  8.3 In the list, find and select the desired language.
  8.4 Click OK.
  8.5 In the Rule description field, type the translation of the validation rule description.
  8.6 In the Message field, type the translation of the validation message.
 

Note:

In the validation message translation, you can use these tags:

  • Field name: When the validation message is shown, the [Field name] tag is replaced with the name of the validated field.
  • Field value: When the validation message is shown, the [Field value] tag is replaced with the value that is entered in the validated field.

To add a tag to the validation message translation, click Message tags, and click the desired tag.
  8.7 Close the page.
9. Close the page.
Related to Notes

Set up validation rule of type Mandatory or Blank

 		 

Set up validation rule of type Range expression

 		 

Set up validation rule of type Data pattern

 		 

Set up validation rule of type Web service

 		 

Set up validation rule of type Configurable lookup

 		 

Set up validation rule of type Custom

 		 

Provide feedback