TD_IDFFT Function Example | Teradata Vantage - TD_IDFFT Examples - 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_IDFFT Input Table DFFT_RESULTS from TD_DFFT Output

SeqNo SeqID Magnitude1 Magnitude2 Magnitude3
0 33 1.0 1.0 1.0
1 33 2.0 2.0 2.0
2 33 3.0 3.0 3.0
3 33 4.0 4.0 4.0
4 33 5.0 5.0 5.0
5 33 6.0 6.0 6.0
6 33 7.0 7.0 7.0
7 33 8.0 8.0 8.0

Example: TD_IDFFT Call

EXECUTE FUNCTION INTO VOLATILE ART(ORIG_SERIES)
TD_IDFFT(
   ART_SPEC(TABLE_NAME(DFFT_RESULTS),
      PAYLOAD(FIELDS(REAL_MAGNITUDE1,IMAG_MAGNITUDE1), CONTENT(COMPLEX)) 
   ),
   FUNC_PARAMS(HUMAN_READABLE(1)) 
);

TD_IDFFT Output

SELECT * FROM ORIG_SERIES;
SeqID ROW_I REAL_REAL_MAGNITUDE1 IMAG_IMAG_MAGNITUDE1
33 0 1.0 -1.1102230246251565E-16
33 1 2.0 -2.220446049250313E-16
33 2 3.0 0.0
33 3 4.0 2.220446049250313E-16
33 4 5.0 1.1102230246251565E-16
33 5 6.0 2.220446049250313E-16
33 6 7.0 0.0
33 7 8.0 -2.220446049250313E-16