Rule Specification Guide

10.5.4
- 10.5.9
- 10.5.6
- 10.5
- 10.4.0
- 10.2.2
- 10.2.1

Back Next

Standardizing Business Data Values

To standardize data values, configure a rule statement that replaces the values with the value that you require. For example, you might configure a rule statement to replace any currency symbol in a data column with the agreed abbreviation for the currency name.

To standardize multiple values, you can create additional rule statements. Alternatively, use a reference table that identifies the values.

Select a rule set in a rule specification.

In the rule set properties, click

Rule Logic

Click

Add Rule Statement

Select an input for the rule statement.

If the rule specification does not contain an input that you can use, create an input. Configure the input properties to represent the type of column that contains the business data.

Select an operator to validate the results of the condition analysis.

To specify that the input data must match the data that you enter, select the following operator: