TD_NonLinearCombineFit Example | NonLinearCombineFit - Example: How to Use TD_NonLinearCombineFit - 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 Input table

 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

Example: Determing Total Cost Using TD_NonLinearCombineFit

SELECT * FROM TD_NonLinearCombineFit (
ON nonLinearCombineFit_input AS InputTable
OUT TABLE FitTable (nonLinearCombineFit_output)
USING
TargetColumns ('SibSp', 'Parch', 'Fare')
Formula ('Y=(X0+X1+1)*X2')
ResultColumn ('TotalCost')
) as dt order by 1;

TD_NonLinearCombineFit Output Table

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