TD_NumApply Syntax Elements - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
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