Skip to content

MAPPING

Processes the mapping in the specified direction. This function uses the cell intersection elements as parameters for the mapping process.

js
MAPPING(mapping_name, mapping_direction)

Parameters

  • mapping_name - The Mapping object name.
  • mapping_direction - Either "LR" or "RL" which dictates the direction we are mapping from and to respectively.

Examples

js
MAPPING("Time to Year and Month", "LR")

Note: The result depends on the mapping table and cell location where the formula applies.