TD_​OutlierFilterFit

OutlierFilterFit function calculates the lower_percentile, upper_percentile, count of rows and median for all the TargetColumns provided by the user. These metrics for each column helps the function OutlierTransform detect outliers in the input table. It also stores parameters from arguments into a FIT table used during transformation.

Options

GroupColumns
Specifies the input table column for which stats calculation needs to be grouped together
IQRMultiplier
Specify the multiplier of interquartile range for 'Tukey' filtering.
LowerPercentile
Specify lower range of percentile to be used to detect if value is outlier or not
OutlierMethod
Specify one of the following methods of filtering outliers
PercentileMethod
Specify the teradata percentile methods to be used for calculation.
RemoveTail
Specify the side of the distribution to filter.
ReplacementValue
Specify one of the following methods of filtering outliers
Output Schema
Output Schema, if Volatile is true then use user login as the schema.
Output Table
Output Table
VAL Location
VAL Location
TargetColumns
Specifies the input table columns for which stats needs to be calculated
Volatile
Specifies whether the table should be a VOLATILE table. If true, then the table is automatically deleted, otherwise it is users responsibility to remove or clean it up for space.
UpperPercentile
Specify upper range of percentile to be used to detect if value is outlier or not

Input Ports

Icon
Connection to a Teradata Database Instance
Icon
The relation that contains input data.

Output Ports

Icon
output of TD_OutlierFilterFit

Nodes

Extensions

Links