Output - Aster Analytics

Teradata AsterĀ® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
lifecycle
previous
Product Category
Software

This query returns the output shown in the table cfilter_output1:

SELECT * FROM cfilter_output1 ORDER BY col1_item1, score;
CFilter Example 2 Output Table cfilter_output1 (Columns 1-7)
col1_item1 col1_item2 cntb cnt1 cnt2 score support
Consumer Small Business 13 13 17 0.764705882352941 0.764705882352941
Consumer Corporate 13 13 17 0.764705882352941 0.764705882352941
Consumer Home Office 13 13 16 0.8125 0.764705882352941
Corporate Consumer 13 17 13 0.764705882352941 0.764705882352941
Corporate Home Office 16 17 16 0.941176470588235 0.941176470588235
Corporate Small Business 17 17 17 1 1
Home Office Consumer 13 16 13 0.8125 0.764705882352941
Home Office Small Business 16 16 17 0.941176470588235 0.941176470588235
Home Office Corporate 16 16 17 0.941176470588235 0.941176470588235
Small Business Consumer 13 17 13 0.764705882352941 0.764705882352941
Small Business Home Office 16 17 16 0.941176470588235 0.941176470588235
Small Business Corporate 17 17 17 1 1
CFilter Example 2 Output Table cfilter_output1 (Columns 8-10)
confidence lift z_score
1 1 -0.98058067569092
1 1 -0.98058067569092
1 1.0625 -0.98058067569092
0.764705882352941 1 -0.98058067569092
0.941176470588235 1 0.784464540552737
1 1 1.37281294596729
0.8125 1.0625 -0.98058067569092
1 1 0.784464540552737
1 1 0.784464540552737
0.764705882352941 1 -0.98058067569092
0.941176470588235 1 0.784464540552737
1 1 1.37281294596729