AntiSelect Example - Teradata Vantage

Machine Learning Engine Analytic Function Reference
Product
Teradata Vantage
Release Number
8.00
1.0
Published
May 2019
Language
English (United States)
Last Update
2019-11-22
dita:mapPath
blj1506016597986.ditamap
dita:ditavalPath
blj1506016597986.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantage™

Input

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

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

SQL Call

SELECT * FROM AntiSelect (
  ON antiselect_input
  USING
  Exclude ('rowids', 'orderdate', 'discount', 'province', 'custsegment')
) AS dt ORDER BY 1, 4;

Output

The output table excludes the specified columns and outputs the remaining columns.

orderid priority quantity sales shipmode custname region prodcat
3 Low 6 261.54 Regular Air Muhammed MacIntyre Nunavut Office Supplies
293 High 27 244.57 Regular Air Barry French Nunavut Office Supplies
293 High 49 10123 Delivery Truck Barry French Nunavut Office Supplies
483 High 30 4965.76 Regular Air Clay Rozendal Nunavut Technology
515 Not Specified 21 146.69 Regular Air Carlos Soltero Nunavut Furniture
515 Not Specified 19 394.27 Regular Air Carlos Soltero Nunavut Office Supplies
613 High 12 93.54 Regular Air Carl Jackson Nunavut Office Supplies