TD_NumApply Example | Teradata Vantage - TD_NumApply Example - Teradata® Database

InputTable: input_table

Every complete example in this document is available in a zip file that you can download. The zip file includes a SQL script file that creates the input tables for the examples. If you are reading this document on https://docs.teradata.com/, you can download the zip file from the attachment in the left sidebar.

passenger survived pclass sex    age sibsp parch fare         cabin embarked                                 
 --------- -------- ------ ------ --- ----- ----- ------------ ----- ------------
         1        0      3 male    22     1     0  7.250000000  null  S                                       
         2        1      1 female  38     1     0  71.280000000 C85   C                                       
         3        1      3 female  26     0     0  7.930000000  null  S                                       
         4        1      1 female  35     1     0  53.100000000 C123  S                                       
         5        0      3 male    35     0     0  8.050000000  null  S                                       

SQL Call

SELECT * FROM TD_NumApply (
  ON numApply_input AS InputTable PARTITION BY ANY
  USING
  TargetColumns ('Age','Fare')
  ApplyMethod ('log')
  Accumulate ('Passenger')
  InPlace ('true')
) AS dt;

Output

 passenger age         fare        
 --------- ----------- ----------- 
         5 3.555348061 2.085672091
         4 3.555348061 3.972176928
         3 3.258096538 2.070653036
         1 3.091042453 1.981001469
         2 3.637586160 4.266615783