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.
The ApplyMap script function is used
for mapping the output of an expression to a previously loaded mapping table.
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.