TD_UNDIFF Function Example | Teradata Vantage - TD_UNDIFF Example - 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
2023-12-08
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743

TD_UNDIFF Call

EXECUTE FUNCTION
TD_UNDIFF(
   SERIES_SPEC(TABLE_NAME(diff0),SERIES_ID(BuoyId), ROW_AXIS(SEQUENCE(ROW_I)),
      PAYLOAD(FIELDS(MAG), CONTENT(REAL))),
   SERIES_SPEC(TABLE_NAME(BuoyData2),SERIES_ID(BuoyId), ROW_AXIS(SEQUENCE(SeqNo)),
      PAYLOAD(FIELDS(Mag), CONTENT(REAL))),
   FUNC_PARAMS(LAG(1),DIFFERENCES(1) SEASONAL_MULTIPLIER(0)),
 
INPUT_FMT(INPUT_MODE(MATCH))
);

TD_UNDIFF Output

BuoyId ROW_I OUT_Mag
----------- ----------- ----------------------
33 0 1.00000000000000E 000
33 1 2.00000000000000E 001
33 2 3.30000000000000E 001
33 3 4.00000000000000E 001
33 4 5.50000000000000E 001
33 5 6.00000000000000E 001
33 6 7.70000000000000E 001
33 7 8.00000000000000E 001
33 8 9.90000000000000E 001
33 9 1.00000000000000E 002
33 10 1.11000000000000E 002
33 11 1.20000000000000E 002
33 12 1.33000000000000E 002
33 13 1.40000000000000E 002
33 14 1.55000000000000E 002
33 15 1.60000000000000E 002