Referencing a Column with Positional (Index) Filtering

You can filter out records of a column based on a range of row indices. For example, consider the table described previously (Referencing a Query Column). To extract the first five records from the 'company_name' column, adapt the formula as follows:

q['[0,company_name]:[4, company_name]'];

An asterisk '*' in place of the row index represents the last row in the result set.

<< Referencing a Column With Expression Filtering © 1996-2013 InetSoft Technology Corporation (v11.4) 3.7.4 Cell Referencing >>