You can configure a step to compare the values in an input string to a dictionary. The step writes a label for each matching value to the output. The step can also return the valid column entry for any input value that matches a dictionary value.
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 string to every value in the dictionary that you select.
4In the Label field, enter a label name that represents the data that you expect to find in an input string.
5Select or clear the Casing option.
If you select the option, the step searches for values in the input string 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 input values.
6Select one of the following modes:
- Inclusive. The step applies a label to each input value that matches a dictionary value.
- Exclusive. The step applies a label to each input value that does not match a dictionary value.
7Select 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.
8If 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.