Antiselect_MLE Example | Teradata Vantage - Antiselect_MLE Example

Antiselect_MLE Example | Teradata Vantage - Antiselect_MLE Example - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product

Teradata Vantage

Release Number

9.02

9.01

2.0

1.3

Published

February 2022

Language

English (United States)

Last Update

2022-02-10

dita:mapPath

rnn1580259159235.ditamap

dita:ditavalPath

ybt1582220416951.ditaval

dita:id

B700-4003

lifecycle

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_MLE(
  ON antiselect_input
  USING
  EXCLUDE ('rowids','orderdate','discount', 'province', 'custsegment')
) AS dt ;

Output

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

 orderid priority   quantity sales     shipmode       custname           region  prodcat         
 ------- ---------- -------- --------- -------------- ------------------ ------- --------------- 
     613 high             12     93.54 regular air    carl jackson       nunavut office supplies
     293 high             49  10123.02 delivery truck barry french       nunavut office supplies
     515 not specif       19    394.27 regular air    carlos soltero     nunavut office supplies
       3 low               6    261.54 regular air    muhammed macintyre nunavut office supplies
     515 not specif       21    146.69 regular air    carlos soltero     nunavut furniture      
     483 high             30 4965.7595 regular air    clay rozendal      nunavut technology     
     293 high             27    244.57 regular air    barry french       nunavut office supplies

Download a zip file of all examples and a SQL script file that creates their input tables.