Page Operations
Browse SpaceDescription
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 |