TD_IDFFT Function Example | Teradata Vantage - TD_IDFFT Examples - 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

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