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