TD_NonLinearCombineTransform Function Example | Teradata Vantage - Example: How to Use TD_NonLinearCombineTransform - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantageā„¢

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