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)

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")

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

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