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.
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 branch code data.
Select 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
Select 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
Select 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.
Configure 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.
Click
OK
.
Optionally, 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.
ASK INFAPreview
