7.00.02 - Input - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Last Update
2018-04-17

The input table, antiselect_input, is a sample set of sales data containing 13 columns.

Antiselect Example Input Table antiselect_input (Columns 1-8)
rowid orderid orderdate priority quantity sales discount shipmode
1 3 2010-10-13 00:00:00 Low 6 261.54 0.04 Regular Air
49 293 2012-10-01 00:00:00 High 49 10123 0.07 Delivery Truck
50 293 2012-10-01 00:00:00 High 27 244.57 0.01 Regular Air
80 483 2011-07-10 00:00:00 High 30 4965.76 0.08 Regular Air
85 515 2010-08-28 00:00:00 Not Specified 19 394.27 0.08 Regular Air
86 515 2010-08-28 00:00:00 Not Specified 21 146.69 0.05 Regular Air
97 613 2011-06-17 00:00:00 High 12 93.54 0.03 Regular Air
Antiselect Example Input Table antiselect_input (Columns 9-13)
custname province region custsegment prodcat
Muhammed MacIntyre Nunavut Nunavut Small Business Office Supplies
Barry French Nunavut Nunavut Consumer Office Supplies
Barry French Nunavut Nunavut Consumer Office Supplies
Clay Rozendal Nunavut Nunavut Corporate Technology
Carlos Soltero Nunavut Nunavut Consumer Office Supplies
Carlos Soltero Nunavut Nunavut Consumer Furniture
Carl Jackson Nunavut Nunavut Corporate Office Supplies