Mapping functions

This section describes functions for handling mapping tables. A mapping table can be used to replace field values or field names during script execution.

Mapping functions can only be used in the data load script.

Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.

ApplyMap

The ApplyMap script function is used for mapping any expression to a previously loaded mapping table.

ApplyMap('mapname', expr [ , defaultexpr ] )

MapSubstring

The MapSubstring script function is used to map parts of any expression to a previously loaded mapping table. The mapping is case sensitive and non-iterative, and substrings are mapped from left to right.

MapSubstring('mapname', expr)