MAKEARRAY (PQL - xl)

This function returns a calculated array of a specified row and column size by applying a LAMBDA

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

Syntax

MAKEARRAY(rows, columns, function)

Function Arguments

Name

Description

Type

Optional

rows

The number of rows in the array. Must be greater than zero

Number

columns

The number of columns in the array. Must be greater than zero

Number

function

A LAMBDA that is called to create the array

String

Comments

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