Arguments - Aster Analytics

Teradata Aster Analytics Foundation User Guide
Product
Aster Analytics
Release Number
6.21
Published
November 2016
Language
English (United States)
Last Update
2018-04-14
dita:mapPath
kiu1466024880662.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1021
lifecycle
previous
Product Category
Software
Argument Category Description
InputTable Required Specifies the name of the table that contains the input data.
OutputTable Required Specifies the name for the table that the function generates for the output.
AutoBin Optional Specifies either the algorithm to be used for selecting bin boundaries or the approximate number of bins to find. The number_of_bins must be a positive integer.
If you specify this argument, you must not specify CustomBinTable, CustomBinColumn, StartValue, BinSize, or EndValue.
CustomBinTable Optional Specifies the name of the table that contains the boundary points between bins.
If you specify this argument, you must also specify CustomBinColumn, and you must not specify AutoBin, StartValue, BinSize, or EndValue.
CustomBinColumn Optional Specifies the name of the bin_table column that contains the boundary values. This column must have a numeric SQL data type.
If you specify this argument, you must also specify CustomBinTable, and you must not specify AutoBin, StartValue, BinSize, or EndValue.
StartValue Optional Specifies the smallest value to use in binning.
If you specify this argument, you must also specify BinSize and EndValue, and you must not specify AutoBin, CustomBinTable, or CustomBinColumn.
EndValue Optional Specifies the largest value to use in binning.
If you specify this argument, you must also specify StartValue and BinSize, and you must not specify AutoBin, CustomBinTable, or CustomBinColumn.
BinSize Optional Specify this argument only for equally sized bins. The bin_size is the width of each bin, a positive DOUBLE PRECISION value.
If you specify this argument, you must also specify StartValue and EndValue, and you must not specify AutoBin, CustomBinTable, or CustomBinColumn.
GroupByColumns Optional Specifies the name of the input_table columns that contain the group values for binning. These columns cannot contain DOUBLE PRECISION or FLOAT values.
Inclusion Optional Specifies whether to include points on bin boundaries in the bin on the left or the bin on the right. The default value is 'left'.
ValueColumn Required Specifies the name of the input_table column for which to compute statistics. This column must have a numeric SQL data type.