You can configure a step to compare the values in an input field to the values in a dictionary. The step writes matching values to one or more output fields.
On the
Configuration
tab, select the option to add a step to the asset.
The
Add Step
dialog box opens onscreen.
Select
Dictionary
as the step type.
In the
Dictionary Properties
pane, select a dictionary.
Use a dictionary that contains a range of data values that you expect the step to find at run time.
The step compares each value in an input field to every value in the dictionary that you select, regardless of the number of columns in the dictionary.
In the
Outputs
field, enter the name of the field to which the step will write any input value that matches a dictionary value. The step creates the field at run time.
Press the Enter key after you enter the field name.
Select or clear the
Casing
option.
If you select the option, the step searches for values in the input fields that match both the spelling and the character case of the values in the dictionary. By default, the step ignores the character case of the values in the input fields.
Select or clear the
Standardization
option.
If you select the option, the step returns the valid value from the dictionary for any input value that matches a dictionary value.
If you select the Standardization option, use the
Valid Column
options to identify the dictionary column that contain the valid values.
The valid column contains the standard or preferred version of a value in cases where the dictionary contains more than one value on a given row.
You can specify any dictionary column as the valid column within a step. To use the column that the dictionary designer set as the valid column, click
ASK INFAPreview
