TD_POWERTRANSFORM Syntax Elements - Teradata Vantage

Database Unbounded Array Framework Time Series Functions
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-04-04
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743
SERIES_SPEC
A time series or spatial series. Series can be REAL or MULTIVAR_REAL.This function accepts a single input source containing univariate series instances or multivariate series instances. The result is univariate or multivariate, respectively.

See Series Specifications.

FUNC_PARAMS
Collectively, the values of BACK_TRANSFORM, P, B, and LAMBDA determine how the function transforms the input time series. See How BACK_TRANSFORM, P, B, and LAMBDA Determine Transform Equation.
Name Data Type Description
BACK_TRANSFORM Integer Indicator to apply back transform. A value of 0 does not apply back transform. A value of 1 applies the back transform. The default is 0.
P FLOAT The power to use in the transform equation.
B FLOAT The logarithm to be applied for the transform.
LAMBDA FLOAT The parameter used to decide the preferred power transform operation during the Box-Cox transformation.
INPUT_FMT
No INPUT_FMT options are available for this function.
OUTPUT_FMT
[Optional] Specify the INDEX_STYLE of the output format. Options are NUMERICAL_SEQUENCE and FLOW_THROUGH. The default is NUMERICAL_SEQUENCE.