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