TD_OutlierFilterTransform Input - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

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.