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
Publication Date
June 2022
Content Type
Reference
Publication ID
B700-1150-172K
ft:locale
en-US
ft:lastEdition
2026-03-23
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
ft:sourceId
dita
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.