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.
1. Select a rule set in a rule specification.
2. In the rule set properties, click Rule Logic.
3. Click Add Rule Statement.
4. Select an input for the rule statement.
- - If the rule set does not contain an input, create an input. Configure the input properties represent the type of column that contains the business data.
5. Configure the condition.
- - Click the condition icon to open the Define Condition dialog box.
- - Select Input.
- - Specify the type of data to enter. Use string data to specify a text value.
- - Enter a data value. For example, enter "$."
- - Click OK.
6. 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
7. Configure the action to write a value when the input data matches the condition data.
- - Click the action icon to open the Define Action dialog box.
- - Select Input.
- - Specify the type of data to enter. Use string data to return a text value.
- - Enter a data value. For example, enter "USD."
- - Click OK.
8. Save the rule specification.
9. Repeat the steps for other currency symbols that you want to standardize.
For example, standardize £ to GBP.