TD_IDFFT Function Example | Teradata Vantage - TD_IDFFT Examples - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

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