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 November 5, 2024