Skip to content

Formulae Using Tables

Jump to bottom
Richard Lin edited this page Oct 8, 2020 · 1 revision

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.

User Guide

  1. Home
  2. Setup Instructions
  3. Developer Environment
  4. Basic Usage
  5. System Design
    1. Architecture
    2. Formula Evaluation
  6. Navigation
    1. Navigational Operations
    2. Aggregation Operations
    3. Bin Customization
    4. History Management
  7. SQL
    1. Formulae Using Tables
    2. Querying Tables
    3. Tables Management
  8. APIs

Clone this wiki locally