Column Specification Arguments - Aster Analytics

Some analytic functions have column specification arguments with this syntax:

argument ( {column | column_range }[,...] )

The column is a column name. The syntax of column_range is:

'start_column:end_column' [, '-exclude_column' ]

The start_column and end_column can be:

• Column names (for example, '[column1:column2]')
• Nonnegative integers that represent the indexes of columns in the table (for example, '[0:4]')

  The first column has index 0; therefore, '[0:4]' specifies the first five columns in the table.

• Empty. For example:
  • '[:4]' specifies all columns up to and including the column with index 4.
  • '[4:]' specifies the column with index 4 and all columns after it.
  • '[:]' specifies all columns in the table.