DataSetColumnRange (PQL)

Returns a list of values found in a column of data in a given query result set, starting from a specific position and ending at a specific position

  • Returned Output: Numeric List
  • Library: PQL \ Dynamic \ Column
  • Version: 2020.18.000
  • Compatibility: Any content (regardless of data source) in the relevant parts of the application

Syntax

DataSetColumnRange( <Column Integer> , <Start Integer> , <End Integer> )

* Click on the function's arguments above for more details on the input values.

Comments
  • The column number is the zero-based index number of the row of data in the result set.
Different Function types

Examples

The examples below use the following example grid.

This example returns the list of values from the "High School" column, starting in rows 0 through 2. (145,408.78 to 167,265.58):

DataSetColumnRange(2, 0,2)