7.00.02 - Correlation Arguments - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Aster Analytics
Release Number
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
English (United States)
Specifies pairs of columns for which to calculate correlations. For each column pair, 'col_name1:col_name2', the function calculates the correlation between col_name1 and col_name2. For each column range, '[col_index1:col_index2]', the function calculates the correlation between every pair of columns in the range. For example, if you specify '[1:3]', the function calculates the correlation between the pairs (1,2), (1,3), (2,3),(1,1),(3,3). The mininum value of col_index1 is 0, and col_index1 must be less than col_index2.
Specifies the name for the Corr_Map output table column that contains the correlations, and by which the Corr_Map output table is partitioned.
[Optional] Specifies the names of the input columns that define the group for correlation calculation. Default behavior: All input columns belong to a single group, for which the function calculates correlation.