TD_BinCodeFit Function Syntax | Teradata Vantage - TD_BinCodeFit Syntax - Teradata® Database

For Equal-Width Bins with Generated Labels

CREATE TABLE primary_output_table AS (
  SELECT * FROM TD_BincodeFit (
    ON { table | view | (query) } AS InputTable
    [ OUT [ PERMANENT | VOLATILE ] TABLE OutputTable (output_table) ]
    USING
    TargetColumns ({ 'target_column' | target_column_range }[,...])
    MethodType ('equal-width')
    NBins ('single bin value' | 'separate bin values')
    [ LabelPrefix ('single prefix' | 'separate prefix values') ]
  ) AS alias
) WITH DATA;

For Variable-Width Bins with Specified Labels

CREATE TABLE primary_output_table AS (
  SELECT * FROM TD_BincodeFit (
    ON { table | view | (query) } AS InputTable
    ON { table | view | (query) } AS FitInput DIMENSION
    USING
    TargetColumns ({ 'target_column' | target_column_range }[,...])
    MethodType ('variable-width')
    [ MinValueColumn ('minvalue_column') ]
    [ MaxValueCOlumn ('maxvalue_column') ]
    [ LabelColumn ('label_column') ]
    [ TargetColNames ('target_names_column') ]
  ) AS alias
) WITH DATA;