Description
The Value Mapper maps string values from one value to another. Mapping is usually solved by storing the conversion table in a database. The Value Mapper provides you with a simple alternative.
For example, if you want to replace language codes:
Fieldname to use: LanguageCode
Target fieldname: LanguageDesc
Source/Target: EN/English, FR/French, NL/Dutch, ES/Spanish, DE/German, ...
Note: You can convert a null field or empty String value to a non-empty value. Leave the Source Value field empty. You can specify one of these empty source field values.
Note 2: Null or empty value won't be mapped to the "Default upon non-matching" value. They stay null. Use the above tip if you want to map them anyway.
Options
The following properties are used to define the mappings:
Option |
Description |
|---|---|
Step name |
Name of the step; this name has to be unique in a single transformation. |
Fieldname to use |
Field to use as the mapping source |
Target field name |
Field to use as the mapping Target |
Default upon non-matching |
Defines a default value for situations where the source value is not empty, but there is no match |
Field values table |
Contains the mapping of source value to converted target value |