Map Function

With the Map function, the input field is transformed via a fixed mapping list. If no appropriate entry is found in the mapping list, the input field remains unchanged or is mapped to the value given under "default".

Parameters

Map	A static mapping table with mapping definitions in from and to columns. (Note that the characters “=” and “,” can currently not be part of the mapping definitions.) Enter #space for a blank value (" ") and #null for a NULL value.
Default	The designated result when no entry for the input field is found in the mapping list. Enter #space for a blank value (" ") and #null for a NULL value.

Example

Updated June 5, 2023