Formulae Using Tables

DataSpread supports a unique value type called Table which returns a group of cells within a range. Functions like SQL and UNION return a Table value.

Index Function

The INDEX function is used in order to view the entries within a Table value.

Syntax

INDEX(table, row, [column])

"table" must be a Table value, while "row" and "column" must be integral Number values.

The rows and columns within a Table value are 1-indexed. When row=0, INDEX operates on the set of table attributes.

When the table only has one column, the column parameter can be omitted.

Example

See the examples in Querying Tables.