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.
1On the Configuration tab, select the option to add a step to the asset.
The Add Step dialog box opens onscreen.
2Select Dictionary as the step type.
3In 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.
4In 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.
5Select 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.
6Select 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.
7If 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 Use Default.