When you configure a cleanse asset, you define one or more steps for the input fields that an instance identifies. A step describes a standardization operation that a mapping can apply to an input field on a Cleanse transformation. The mapping applies the steps in a sequence that you define in the cleanse asset.
You can configure multiple steps for the input fields in a cleanse asset. The mapping applies the steps to one or more input fields that you select in the Cleanse transformation.
When you add a step to a cleanse asset, you choose from the following options:
Convert Case
Updates the character case of the data in an input field. For example, you can convert a field of mixed-case characters to uppercase characters. You can select or clear an option to ignore uppercase values in the input data.
Remove Values
Searches an input field for one or more values that you specify, and removes the values.
You can enter one or more values that the mapping will remove. Or, you can use a dictionary to identify the values that the mapping will remove.
Remove Spaces
Removes redundant character spaces from an input field.
You can remove leading and trailing spaces, and you can replace multiple spaces with a single space.
Replace Values
Searches an input field for one or more values that you specify, and replaces the values. You can find and replace values in the following ways:
- Enter one or more values that the mapping can search for. Enter a single replacement value for every value that the mapping finds.
- Use a dictionary to identify multiple strings that the mapping can search for. Use the same dictionary to specify a replacement value for each value that the mapping finds.
- Use a dictionary to identify multiple strings that the mapping can search for. Enter a single replacement value for every value that the mapping finds.