To standardize data values, configure a rule statement that replaces an input value with a value that you require. For example, you might configure a rule statement to replace terms that identify a Development environment with terms that identify a Production environment.
To standardize multiple values, you can create additional rule statements. Alternatively, use a dictionary 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:
is
Select the type of condition to apply to the input.
To compare the input data to a string value, select the following condition type:
string value
Enter the value to compare to the input data. For example, enter DEV.
Select the type of action to apply to the data that satisfies the condition logic.
To return a string value, select the following action type:
string value
Enter the value that the action returns. For example, enter PROD.