Results Data | Matrix Building | Vantage Analytics Library - Results Data - Vantage Analytics Library

Vantage Analytics Library User Guide
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Vantage Analytics Library
Release Number
2.2.0
Published
March 2023
Language
English (United States)
Last Update
2024-01-02
dita:mapPath
ibw1595473364329.ditamap
dita:ditavalPath
iup1603985291876.ditaval
dita:id
zyl1473786378775
Product Category
Teradata Vantage
Table columns in bold comprise the Unique Primary Index (UPI).
Column Data Type Description
rownum INTEGER Row number.
rowname VARCHAR Column names specified by columns.
c INTEGER [Column appears only if matrixtype = ESSCP.]

Count, an extension of Sum of Squares.
s INTEGER [Column appears only if matrixtype = ESSCP.]

Sum, an extension of Sum of Squares.
column_name VARCHAR [Column appears once for each column specified by columns.]

Examples

matrixtype = COR
rownum rowname age years_with_bank nbr_children
1 age 1 0.181478 -0.057194
2 years_with_bank 0.181478 1 -0.034813
3 nbr_children -0.057194 -0.034813 1
matrixtype = COV
rownum rowname age years_with_bank nbr_children
1 age 365.378590 9.281592 -1.206326
2 years_with_bank 9.2815928 7.159016 -0.102781
3 nbr_children -1.206326 -0.102781 1.217513
matrixtype = SSCP
rownum rowname age years_with_bank nbr_children
1 age 1620524 130921 21784
2 years_with_bank 130921 16747 2010
3 nbr_children 21784 2010 1290
matrixtype = CSSCP
rownum rowname age years_with_bank nbr_children
1 age 272572.428380 6924.068273 -899.919678
2 years_with_bank 6924.068273 5340.626506 -76.674698
3 nbr_children -899.919678 -76.674698 908.2650602
matrixtype = ESSCP (Default)
rownum rowname c s age years_with_bank nbr_children
1 age 747 31732 1620524 130921 21784
2 years_with_bank 747 2919 130921 16747 2010
3 nbr_children 747 534 21784 2010 1290