TD_BinCodeFit Function Example | Teradata Vantage - TD_BinCodeFit Example - 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™

InputTable: bin_titanic_train

Every complete example in this document is available in a zip file that you can download. The zip file includes a SQL script file that creates the input tables for the examples. If you are reading this document on https://docs.teradata.com/, you can download the zip file from the attachment in the left sidebar.

passenger survived pclass name                                 sex    age sibsp parch ticket   fare         cabin       embarked 
 --------- -------- ------ ------------------------------------ ------ --- ----- ----- -------- ------------ ----------- -------- 
        97        0      1 Goldschmidt; Mr. George B            male    71     0     0 PC 17754 34.654200000 A5          C       
       488        0      1 Kent; Mr. Edward Austin              male    58     0     0 11771    29.700000000 B37         C       
       505        1      1 Maioni; Miss. Roberta                female  16     0     0 110152   86.500000000 B79         S       
       631        1      1 Barkworth; Mr. Algernon Henry Wilson male    80     0     0 27042    30.000000000 A23         S       
       873        0      1 Carlsson; Mr. Frans Olof             male    33     0     0 695       5.000000000 B51 B53 B55 S       

Input: FitInput table

 ColumnName   MinValue     MaxValue     Label      
 ---------- ------------ ------------ ---------- 
 age           0.00 	  20.00 	Young Age 
 age          21.00 	  45.00 	Middle Age
 age          46.00 	  90.00		Old Age   

SQL Call

CREATE TABLE FitOutputTable AS (
  SELECT * FROM TD_BincodeFit (
    ON bin_titanic_train AS InputTable
    ON FitInputTable AS FitInput DIMENSION
    USING
    TargetColumns ('age’)
    MethodType ('Variable-Width')
    MinValueColumn ('MinValue')
    MaxValueCOlumn ('MaxValue')
    LabelColumn ('Label')
    TargetColNames ('ColumnName')
  ) AS dt
) WITH DATA;

Output

TD_ColumnName_BINFIT TD_MinValue_BINFIT TD_MaxValue_BINFIT TD_Label_BINFIT TD_Bins_BINFIT TD_IndexValue_BINFIT TD_MaxLenLabel_BINFIT age  
 -------------------- ------------------ ------------------ --------------- -------------- -------------------- --------------------- ---- 
 age                        46.000000000       90.000000000 Old Age                      3                    0                    10 null
 age                        21.000000000       45.000000000 Middle Age                   3                    0                    10 null
 age                         0.000000000       20.000000000 Young Age                    3                    0                    10 null