Column Specification Arguments - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
lifecycle
previous
Product Category
Software
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 range includes its endpoints.

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.

The exclude_column is a column in the specified range, represented by either its name or its index (for example, '[0:99]', '-[50]', '-column10' specifies the columns with indices 0 through 99, except the column with index 50 and column10.

Column ranges cannot overlap, and cannot include any column specified in column_list.