MAP (PQL - xl)

This function returns an array formed by mapping each value in the array(s) to a new value by applying a LAMBDA to create a new value

  • Library: PQL \ Spreadsheet \ Logical
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

MAP(array, lambda or array2)

Function Arguments

Name

Description

Type

Optional

array

An array to be mapped

StringOrNumber

lambda or array2

A LAMBDA which must be the last argument and must have either a parameter for each array passed, or another array to be mapped

String

Comments

This function is the same as the Microsoft Excel 'MAP' function - using the same inputs, logic and outputs.