Skip to content
Mathias Wulff edited this page Oct 31, 2022 · 5 revisions

Keyword MATRIX

Result modifier for a SELECT

Suggested syntax:

    MATRIX OF SELECT ...

Alternative syntax:

    SELECT MATRIX ...

Return data as an array of arrays (one array per row) instead of the default array of javascript objects. Row order is as requested in the select.

You can set query modifier for all SELECTs via:

    alasql.options.modifier = 'MATRIX';

See also: RECORDSET, VALUE, ROW, COLUMN

Clone this wiki locally