Interpolator - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Publication Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
ft:locale
en-US
ft:lastEdition
2019-11-22
dita:mapPath
blj1506016597986.ditamap
dita:ditavalPath
blj1506016597986.ditaval
ft:sourceId
dita
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

The Interpolator function calculates missing values in a time series, using either interpolation or aggregation. Interpolation estimates missing values between known values. Aggregation combines known values to produce an aggregate value.

The time intervals between calculated values can either be the same length (specified by the TimeInterval argument) or have specific start and end times (specified by time_table). The choice of TimeInterval or time_table affects the behavior of interpolation, but not aggregation.