TD_FunctionTransform Example | FunctionTransform - TD_FunctionTransform Example - 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_FunctionTransform Input

TD_FunctionTransform 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;

TD_FunctionTransform Output

passenger     survived       pclass  name                                                                                        gender                         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