TD_OutlierFilterFit Output - 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™

FitTable (fit_table) Schema

Column Data Type Description
TD_OutlierMethod_OFTFIT VARCHAR

(CHARACTER SET UNICODE)

Value of OutlierMethod ('percentile', 'tukey', or 'carling').
group_column Same as in Input table [Column appears only if you specify GroupColumns.] Column by which 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.] 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.