TD_POWERTRANSFORM Syntax Elements - Teradata Vantage

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-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.