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

Source Table Used in Example

SELECT BuoyID, ROW_I, COLUMN_I, MAGNITUDE FROM DFFT2_TestMatrix16 ORDER BY 1,2,3;
BuoyID ROW_I COLUMN_I MAGNITUDE
----------- ----------- ----------- ----------------------
33 0 0 1.00000000000000E 000
33 0 1 5.00000000000000E 000
33 0 2 9.00000000000000E 000
33 0 3 1.30000000000000E 001
33 1 0 2.00000000000000E 000
33 1 1 6.00000000000000E 000
33 1 2 1.00000000000000E 001
33 1 3 1.40000000000000E 001
33 2 0 3.00000000000000E 000
33 2 1 7.00000000000000E 000
33 2 2 1.10000000000000E 001
33 2 3 1.50000000000000E 001
33 3 0 4.00000000000000E 000
33 3 1 8.00000000000000E 000
33 3 2 1.20000000000000E 001
33 3 3 1.60000000000000E 001

TD_DFFT2 Call on Source Table

EXECUTE FUNCTION INTO VOLATILE ART(DFFT2)
TD_DFFT2(
   MATRIX_SPEC(TABLE_NAME(DFFT2_TestMatrix16), MATRIX_ID(BuoyID),
      ROW_AXIS(SEQUENCE(ROW_I)),
      COLUMN_AXIS(SEQUENCE(COLUMN_I)),PAYLOAD( FIELDS(MAGNITUDE),
      CONTENT(REAL))),
   FUNC_PARAMS(FREQ_STYLE("K_INTEGRAL"), HUMAN_READABLE(0)),
   OUTPUT_FMT(CONTENT(COMPLEX))
);

TD_IDFFT2 Call to Restore Original Values of Source Table

EXECUTE FUNCTION INTO VOLATILE ART(IDFFT2)
TD_IDFFT2(MATRIX_SPEC(TABLE_NAME(DFFT2), MATRIX_ID(BuoyID),
      ROW_AXIS(SEQUENCE(ROW_I)),
 
      COLUMN_AXIS(SEQUENCE(COLUMN_I)),
      PAYLOAD( FIELDS(REAL_MAGNITUDE, IMAG_MAGNITUDE), CONTENT(COMPLEX))),
   FUNC_PARAMS(HUMAN_READABLE(0)) 
);

TD_IDFFT2 Output

SELECT * FROM IDFFT2;
BuoyID ROW_I COLUMN_I REAL_REAL_MAGNITUDE IMAG_IMAG_MAGNITUDE
----------- ----------- ----------- ---------------------- ----------------------
33 0 0 1.00000000000000E 000 0.00000000000000E 000
33 0 1 5.00000000000000E 000 2.28847549044393E-017
33 0 2 9.00000000000000E 000 0.00000000000000E 000
33 0 3 1.30000000000000E 001 -2.28847549044393E-017
33 1 0 2.00000000000000E 000 5.72118872610983E-018
33 1 1 6.00000000000000E 000 2.86059436305492E-017
33 1 2 1.00000000000000E 001 5.72118872610983E-018
33 1 3 1.40000000000000E 001 -1.71635661783295E-017
33 2 0 3.00000000000000E 000 0.00000000000000E 000
33 2 1 7.00000000000000E 000 2.28847549044393E-017
33 2 2 1.10000000000000E 001 0.00000000000000E 000
33 2 3 1.50000000000000E 001 -2.28847549044393E-017
33 3 0 4.00000000000000E 000 -5.72118872610983E-018
33 3 1 8.00000000000000E 000 1.71635661783295E-017
33 3 2 1.20000000000000E 001 -5.72118872610983E-018
33 3 3 1.60000000000000E 001 -2.86059436305492E-017