TD_OutlierFilterTransform Function Example | Teradata Vantage - TD_OutlierFilterTransform Example - Teradata® Database

Database Analytic Functions

Product
Teradata® Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/wnd1589838592459.ditamap
dita:ditavalPath
Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/ayr1485454803741.ditaval
dita:id
B035-1206
lifecycle
previous
Product Category
Teradata Vantage™

Input

SQL Call

SELECT * FROM TD_OutlierFilterTransform (
  ON titanic AS InputTable PARTITION BY ANY
  ON outlier_fit AS FitTable DIMENSION
) AS dt;

Output

passenger pclass fare         survived 
 --------- ------ ------------ -------- 
         1      3  8.050000000        0
         2      1  8.050000000        1
         3      3  7.925000000        1
         4      1 53.100000000        1
         5      3  8.050000000        0