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.
TD_SimpleImputeFit InputTable: simpleimputefit_input
passenger pclass gender fare survived --------- ------ ------ ------- -------- 1 3 male 725.320 0 2 1 female 712.250 1 3 null female null 1 4 1 null 531.780 1 5 3 male 805.210 0
TD_SimpleImputeFit SQL Call
CREATE TABLE fit_table AS ( SELECT * FROM TD_SimpleImputeFit ( ON simpleimputefit_input AS InputTable USING ColsForLiterals ('Pclass') Literals ('2') ColsForStats ('Gender','Fare') Stats ('mode','median') ) AS dt ) WITH DATA;
TD_SimpleImputeFit Output
TD_INDEX_SIMFIT TD_TARGETCOLUMN_SIMFIT TD_NUM_COLVAL_SIMFIT TD_STR_COLVAL_SIMFIT TD_ISNUMERIC_SIMFIT --------------- ---------------------- -------------------- -------------------- ------------------- 1 pclass 2.000 null 1 2 gender null male 0 3 fare 718.785 null 1