To find values that are no longer valid in a data set, configure a rule statement to read a dictionary that contains known data errors. For example, a national organization updates the codes that identify branch offices. The organization changes the code structure from eight digits to ten digits. You might configure a rule statement to read a dictionary that contains the obsolete eight-digit codes.
If the rule statement finds an obsolete branch code in the input data, it writes a value that you specify as output.
1Select a rule set in a rule specification.
2In the rule set properties, click Rule Logic.
3Click Add Rule Statement.
4Select 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 branch code data.
5Select an operator to validate the results of the condition analysis.
- To specify that the input data must match the data in the condition, select the following operator:
is
6Select the type of condition to apply to the input.
- To compare the input data to the data from another input, select the following condition type:
input
7Select the input that you selected in step 4.
The rule statement compares the input to itself. Therefore, the rule statement passes all of the input data values from the condition to the action.
8Configure the action to search the input data for obsolete branch codes.
- Open the Define Action dialog box.
- Select Standardize, and select Replace Dictionary Matches with Custom Strings.
- Select the input that you specified in the condition.
- Select the dictionary that contains the obsolete values. You must also select or verify the valid value column in the dictionary.
- Enter the data value that the action returns when an input data value matches a dictionary value. For example, enter OBSOLETE_CODE.
9Click OK.
10Optionally, update the default rule statement to return the input data value if the action does not find a dictionary match with the value. Select input as the action type, and then select the input column that you selected in step 4.
When you update the default rule statement in this way, the action can write an output for each row of input data.