Results Data | Association Rules | 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

For each item pair specified by combinations, the function outputs a table with the following format. The ITEMXOFY columns comprise the UPI.

Column Data Type Description
ITEMxOFy Data type of column specified by itemcolumn [Column appears twice or more, depending on number of combinations.] x has all values in range [1, n], where n is number of item pairs specified by combinations.

y is sum of number of items specified.

Examples:
  • combinations=11 produces columns ITEM1OF2 and ITEM2OF2.
  • combinations=12 produces columns ITEM1OF3, ITEM2OF3, and ITEM3OF3.
  • combinations=11,12 produces columns ITEM1OF2, ITEM2OF2, ITEM1OF3, ITEM2OF3, and ITEM3OF3.
LSUPPORT DECIMAL(18,5) Support of left-side item (antecedent).
RSUPPORT DECIMAL(18,5) Support of right-side item (consequent).
SUPPORT DECIMAL(18,5) Support of association (antecedent and consequent).
CONFIDENCE DECIMAL(18,5) Confidence of association.
LIFT DECIMAL(15,5) Lift of association.
ZSCORE DECIMAL(15,5) Z-score of association.