TD_BinCodeFit Syntax | BinCodeFit | Teradata Vantage - TD_BinCodeFit Syntax - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

For Equal-Width Bins with Generated Labels

  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') ]
  )

For Variable-Width Bins with Specified Labels

  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') ]
  )
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