Replacing instances of dictionary values with a value that you specify
Replacing instances of dictionary values with a value that you specify
You can configure a step to replace instances of values that appear in a dictionary with a value that you enter in the step properties. You might use a dictionary when the list of values to replace is too long to enter as custom values. You might also use a dictionary when you will reuse the list of values in multiple cleanse steps.
On the
Configuration
tab of the cleanse asset, click
Add Step
.
Select the
Replace Values
option.
In the step properties pane, select
Replace Dictionary Matches with a New Data Value
.
Select the dictionary to use in the step.
Click
Browse
to select the dictionary. You can preview the dictionary contents in the Step Properties pane.
Select the valid column for the dictionary. The valid column contains the versions of the dictionary values that you designate as the preferred or correct values for the current operation.
The search operation ignores the values in the valid column. However, if a value in the valid column also appears in another dictionary column, the search operation selects the value for replacement with the new value.
Select or clear the option to perform a case-sensitive comparison between the dictionary data and the input data.
Verify the delimiter that the mapping will use to recognize discrete values in the input field. You can specify one or more delimiters.
The input delimiter determines how the mapping reads the input data when you select the Start or End option as the scope.
Set the scope for the search operation.
You can set the following options:
Anywhere. Replaces any instance of the value that occurs in the input field. Can replace multiple instances of the same value in a field.
Start. Replaces any instance of the value that is not preceded by another value in the input field.
End. Replaces any instance of the value that is not followed by another value in the input field.
ASK INFAPreview
