Value Mapper


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.


The following properties are used to define the mappings:



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

Metadata Injection Support

All fields of this step support metadata injection. You can use this step with ETL Metadata Injection to pass metadata to your transformation at runtime.