5.2 Accessing Data With Relative References

The keywords below allow you to access cells within a table or Selection List by using relative indexing (i.e., reference in relation to current cell).

Syntax

Description

field['col_name']

Value in the current row of column named “col_name.”

row

Row index of the current cell.

col

Column index of the current cell.

data[rowIx][colIx]

Value of the data at index [rowIx,colIx] in the raw data (before grouping or summarization). Indices may use keywords 'row' and 'col' to create relative references.

table[rowIx][colIx]

Value of the data at [rowIx,colIx] in the table (as displayed). Indices may use keywords 'row' and 'col' to create relative references.

value

Value of the current cell.

You can type these keywords manually into your script, or you can click the appropriate node on the 'Component' tree in the Script Editor.

 

The following sections illustrate how to access data using these keywords.

See Also

Accessing Data With Absolute/Mixed References, for information on absolute references.

<< 5.1 Accessing Table Data © 1996-2013 InetSoft Technology Corporation (v11.4) 5.2.1 Accessing Data in the Current Cell ('value') >>