TD_OutlierFilterFit (
ON { table | view | (query) } AS InputTable
[OUT [ PERMANENT | VOLATILE ] TABLE OutputTable(output_table_name)]
USING
TargetColumns ({ 'target_column' | target_column_range }[,...])
[GroupColumns ('group_column')]
[OutlierMethod ({ 'percentile' | 'tukey' | 'carling' })]
[LowerPercentile (min_value)]
[UpperPercentile (max_value)]
[IQRMultiplier (k)]
[ReplacementValue ({ 'delete' | 'null' | 'median' | replacement_value})]
[RemoveTail ({ 'both' | 'upper' | 'lower' })]
[PercentileMethod ({ 'PercentileCont' | 'PercentileDISC' })]
)
You can call this function from:
- The FROM clause of a SELECT statement
- As part of a CREATE TABLE statement
- As part of a CREATE VIEW statement