TD_SimpleImputeTransform Example | SimpleImputeTransform - Example: How to Use TD_SimpleImputeTransform - Teradata VantageCloud Lake

Lake - Analyze Your Data with ClearScape Analytics™

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2026-02-20
dita:mapPath
tcl1683670667798.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
tcl1683670667798

TD_SimpleImputeTransform Input Table

 passenger pclass gender fare          survived 
 --------- ------ ------ ----          -------- 
         1      3 male   725.320000000        0
         2      1 female 712.250000000        1
         3   null female          null        1
         4      1 null   531.780000000        1
         5      3 male   805.210000000        0

Output Table from TD_SimpleImputeFit Function

 TD_INDEX_SIMFIT  TD_TARGETCOLUMN_SIMFIT  TD_NUM_COLVAL_SIMFIT  TD_STR_COLVAL_SIMFIT   TD_ISNUMERIC_SIMFIT 
 ---------------  ----------------------  --------------------  --------------------   ------------------- 
               1   pclass                      2.000000000         null                           1
               2   gender                             null         male                           0
               3   fare                      718.785000000         null                           1

Example: TD_SimpleImputeTransform SQL Call

SELECT * FROM TD_SimpleImputeTransform (
  ON simpleimputefit_input AS InputTable
  ON fit_table AS FitTable DIMENSION
) AS dt;

TD_SimpleImputeTransform Output

 passenger pclass gender fare          survived 
 --------- ------ ------ ----          -------- 
         5      3 male   805.210000000        0
         4      1 male   531.780000000        1
         3      2 female 718.785000000        1
         1      3 male   725.320000000        0
         2      1 female 712.250000000        1