TD_NonLinearCombineTransform Function Example | Teradata Vantage - Example: How to Use TD_NonLinearCombineTransform - 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_NonLinearCombineFit InputTable

 passenger survived pclass  gender age sibsp parch fare         cabin embarked                                 
 --------- -------- ------- ------ --- ----- ----- ------------ ----- -------- 
         1        0 General male    22     1     0  7.250000000 null  S                                       
         2        1 Deluxe  female  38     1     1 71.280000000 C85   C                                       
         3        1 General female  26     0     0  7.930000000 null  S                                       
         4        1 Deluxe  female  35     1     0 53.100000000 C123  S                                       
         5        0 General male    35     0     1  8.050000000 null  S

TD_NonLinearCombineFit Output

total_cost      sibsp  parch  fare
--------------- -----  -----  ----
Y=(X0+X1+1)*X2  null   null   null

TD_NonLinearCombineTransform SQL Call

SELECT * FROM TD_NonLinearCombineTransform (
ON nonLinearCombineFit_input AS InputTable
ON nonLinearCombineFit_output AS FitTable DIMENSION
USING
Accumulate('Passenger')
) as dt order by 1;

TD_NonLinearCombineTransform Output Table

passenger TotalCost     
--------- ---------- 
        1  14.50000
        2 213.84000
        3   7.93000
        4 106.20000
        5  16.10000