TD_UNNORMALIZE Output - 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

This function outputs a univariate or multivariate result series. The number of result fields depends on the primary input payload-fields content. There is one result column produced for every field referenced in the primary input payload-fields list. In general, if the primary input payload-content was REAL, then a univariate series of type REAL is produced as a result series. If the primary input payload-content was MULTIVAR_REAL, then a univariate series of type MULTIVAR_REAL is produced as a result series.

RETURNS TABLE Schema
Name Data Type Description
derived-series-identifier Varies The resultant series identifier from the SERIES_ID.
ROW_I Varies Index of result series. Data type varies depending on the OUTPUT_FMT:INDEX_STYLE parameter.
primary-input-payload-field REAL Unnormalized magnitudes of a previously-normalized series. There is one result column produced for each field that appeared in the input payload-fields list, and in the same order. The field name is same as the field name associated with the corresponding field in that payload list.