Input
- InputTable: titanic_data, as in TD_FunctionFit Example
- FitTable: fit_out, created by TD_FunctionFit Example
SQL Call
SELECT * FROM TD_FunctionTransform (
ON function_input_table AS InputTable
ON fit_out AS FitTable DIMENSION
USING
IDColumns ('[0:2]','[6:7]')
) AS dt ORDER BY Passenger;
Output
passenger survived pclass name sex age sibsp parch ticket fare cabin embarked
----------- ----------- ----------- ------------------------------------------------------------------------------------------ ---------- ---------------------- ----------- ----------- -------------------- ---------------------- -------------------- ----------
1 0 3 Braund; Mr. Owen Harris male 4.45943161863730E 000 1 0 A/5 21171 5.25625000000000E 001 S
2 1 1 Cumings; Mrs. John Bradley (Florence Briggs Thayer) female 5.24792751344359E 000 1 0 PC 17599 5.08130885889000E 003 C85 C
3 1 3 Heikkinen; Miss. Laina female 4.70043971814109E 000 0 0 STON/O2. 3101282 6.28056250000000E 001 S
4 1 1 Futrelle; Mrs. Jacques Heath (Lily May Peel) female 5.12928301694497E 000 1 0 113803 2.81961000000000E 003 C123 S
5 0 3 Allen; Mr. William Henry male 5.12928301694497E 000 0 0 373450 6.48025000000000E 001 S