TD_OutlierFilterFit Example | OutlierFilterFit | Teradata Vantage - Example: Using TD_OutlierFilterFit with Percentile Method - Teradata Vantage

Every complete example in this document is available in a zip file that you can download. The zip file includes a SQL script file that creates the input tables for the examples. If you are reading this document on https://docs.teradata.com/, you can download the zip file (SQLE-Analytic-Functions-Examples_xxxx) from the attachment in the left pane.

TD_OutlierFilterFit InputTable: titanic

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

TD_OutlierFilterFit SQL Call

CREATE TABLE outlier_fit AS (
  SELECT * FROM TD_OutlierFilterFit (
  ON titanic AS InputTable
  OUT TABLE OutputTable (outlier_fit)
  USING
  TargetColumns ('Fare')
  LowerPercentile (0.1)
  UpperPercentile (0.9)
  OutlierMethod ('Percentile')
  ReplacementValue ('median')
  PercentileMethod ('PercentileCont')
 ) AS dt
WITH DATA;

TD_OutlierFilterFit Output