TD_NumApply Syntax Elements - Teradata® Database

Database Analytic Functions

Product
Teradata® Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/wnd1589838592459.ditamap
dita:ditavalPath
Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/ayr1485454803741.ditaval
dita:id
B035-1206
lifecycle
previous
Product Category
Teradata Vantage™
TargetColumns
Specify the names of the InputTable columns to which to apply the numeric operator.
OutputColumns
[Ignored with Inplace ('true'), otherwise optional.] Specify names for the output columns. An output_column cannot exceed 128 characters.
Default: With InPlace ('false'), target_column_operator; otherwise target_column
If any target_column_operator exceeds 128 characters, specify an output_column for each target_column.
Accumulate
[Optional] Specify the names of the InputTable columns to copy to the output table.
With InPlace ('true'), no target_column can be an accumulate_column.
ApplyMethod
Specify one of these numeric operators:
num_operator Description
EXP Raises e (base of natural logarithms) to power of value, where e = 2.71828182845905.
LOG Computes base 10 logarithm of value.
SIGMOID Applies sigmoid function to value. See SigmoidStyle.
SININV Computes inverse hyperbolic sine of value.
TANH Computes hyperbolic tangent of value.
SigmoidStyle
[Required with ApplyMethod ('sigmoid'), otherwise ignored.] Specify the sigmoid style.
Default: logit
InPlace
[Optional] Specify whether the output columns have the same names as the target columns.
InPlace ('true') effectively replaces each value in each target column with the result of applying num_operator to it.
InPlace ('false') copies the target columns to the output table and adds output columns whose values are the result of applying num_operator to each value.
With InPlace ('true'), no target_column can be an accumulate_column.
Default: true