Map Values
Enables changing values within a column with a specified Mapping formula or based on comparison criteria from a related table. If the expected values are not found, the Map Value transformation step can return;
Original value
Null value
Blank/empty string
Write custom value
The results can either Override Input Column, or create a new Column.
When value replacement is a list of custom values, you can paste a 2 column tab delimited list from Excel (or similar) by clicking the Paste Multiple Values button.
Search is not case sensitive.
When performing a replacement on a text column from List of Custom Values, you can use {blank}
to represent an empty string and {null}
to represent a null value:
The percent sign % is the search wildcard to be used to match any characters before and after the string to search.
i.e. %verb% returns all values which include the word “verb” anywhere in the text string
Last updated