TD_OutlierFilterTransform Input - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantageā„¢

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.