TD_OutlierFilterTransform Input - Teradata VantageCloud Lake

Lake - Analyze Your Data with ClearScape Analytics™

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2026-02-20
dita:mapPath
tcl1683670667798.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
tcl1683670667798

InputTable Schema

Column Data Type Description
target_column NUMERIC Input table column names for computing metrics and filtering outliers.
group_column Any [Optional] Column to group input data.

FitTable Schema

Column Data Type Description
TD_OutlierMethod_OFTFIT VARCHAR

(CHARACTER SET UNICODE)

Value of OutlierMethod ('percentile', 'tukey', or 'carling').
group_column Any [Column appears only if you specify GroupColumns.]

Column that input data is grouped.

TD_IQRMultiplier_OFTFIT NUMERIC Value of IQRMultiplier (k).
TD_RemoveTail_OFTFIT VARCHAR

(CHARACTER SET UNICODE)

Value of RemoveTail ('both', 'upper', or 'lower').
TD_ReplacementValue_OFTFIT VARCHAR

(CHARACTER SET UNICODE)

Value of ReplacementValue ('delete', 'null', 'median', or replacement_value).
TD_MinThreshold_OFTFIT NUMERIC Value of LowerPercentile (min_value).
TD_MaxThreshold_OFTFIT NUMERIC Value of UpperPercentile (max_value).
TD_AttributeValue_OFTFIT VARCHAR

(CHARACTER SET UNICODE)

[Column appears once for each specified target_column.]
TD_CountValue_OFTFIT NUMERIC Count of rows in group_column if you specify GroupColumns, otherwise count of rows in input table.
TD_MedianValue_OFTFIT NUMERIC Median values for target columns.
TD_LowerPercentile_OFTFIT NUMERIC Lower percentile of input data values, calculated by method specified by PercentileMethod (PercentileCont or PercentileDISC).
TD_UpperPercentile_OFTFIT NUMERIC Upper percentile of input data values, calculated by method specified by PercentileMethod.