Results Data | Frequency Analysis | 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

The following table describes the function results data. If the function creates an output table, the bold columns comprise its Unique Primary Index (UPI).

style=basic
Column Data Type Description
xtbl VARCHAR (128) Table with frequency values, specified by tablename.
xcol VARCHAR (128) Column with frequency variable, specified by columns. Any number of columns can be specified.
xval VARCHAR (256) Distinct value of frequency variable.
xcnt FLOAT Count of rows where frequency variable equals distinct value in xval.
xpct FLOAT Percentage of rows where frequency variable equals distinct value in xval.
xmin_column_name FLOAT [If cumulativeoption=false, column appears once for each column specified by statisticscolumns.] Minimum value of distinct value in xval.
xmax_column_name FLOAT [If cumulativeoption=false, column appears once for each column specified by statisticscolumns.] Maximum value of distinct value in xval.
xmean_column_name FLOAT [If cumulativeoption=false, column appears once for each column specified by statisticscolumns.] Mean of distinct value in xval.
xstd_column_name FLOAT [If cumulativeoption=false, column appears once for each column specified by statisticscolumns.] Standard deviation of distinct value in xval.
xcum_cnt FLOAT [Column appears only if cumulativeoption=true and you omit statisticscolumns.] Cumulative count of rows where frequency variable equals distinct value in xval.
xcum_pct FLOAT [Column appears only if cumulativeoption=true and you omit statisticscolumns.] Cumulative percentage of rows where frequency variable equals distinct value in xval.
xrank FLOAT [Column appears only if cumulativeoption=true and you omit statisticscolumns.] Rank, with respect to all frequencies, where frequency variable equals distinct value in xval.
style=crosstab
Name Type Definition
column_name Same as in input table [Column appears once for each column specified by columns.] Column for which crosstab frequency was calculated.
xcnt FLOAT Count of rows where frequency variable equals distinct value in column_name.
xpct FLOAT Percentage of rows where frequency variable equals distinct value in column_name.
xcum_cnt FLOAT [Column appears only if cumulativeoption=true and you omit statisticscolumns.] Cumulative count of rows where frequency variable equals distinct value in column_name.
xcum_pct FLOAT [Column appears only if cumulativeoption=true and you omit statisticscolumns.] Cumulative percentage of rows where frequency variable equals distinct value in column_name.
xrank FLOAT [Column appears only if cumulativeoption=true and you omit statisticscolumns.] Rank, with respect to all frequencies, where frequency variable equals distinct value in column_name.
style=pairwise
Name Type Definition
xtbl VARCHAR (128) Table with frequency values, specified by tablename.
col1 VARCHAR (30) Column representing first frequency variable, specified by columns Any number of columns can be specified in two groups.
val1 VARCHAR (256) Distinct values of first frequency variable.
col2 VARCHAR (30) Column representing second frequency variable, specified by columns.
val2 VARCHAR (256) Distinct values of second frequency variable.
xcnt FLOAT Count of rows where pairwise combination of frequency variables equals pair of distinct value in val1 and val2.
xpct FLOAT Percentage of rows where pairwise combination of frequency variables equals pair of distinct value in val1 and val2.