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.