TD_DFFT2CONV Function Example | Teradata Vantage - TD_DFFT2CONV Example - Teradata Vantage

TD_DFFT2CONV Input from TD_DFFT2 Output

BuoyID ROW_I COLUMN_I REAL_MAGNITUDE IMAG_MAGNITUDE
----------------------------------------------------
33     0    0         136.00000       0.0000
33     0    1         -32.00000       32.0000
33     0    2         -32.00000       0.00000
33     0    3         -32.00000       -32.0000
33     1    0         -8.0000         8.0000
33     1    1         0.0000          0.0000
33     1    2         0.0000          0.0000
33     1    3         0.0000          0.0000
33     2    0         -8.0000         0.0000
33     2    1         0.0000          0.0000
33     2    2         0.0000          0.0000
33     2    3         0.0000          0.0000
33     3    0         -8.0000         -8.0000
33     3    1         0.0000          0.0000
33     3    2         0.0000          0.0000
33     3    3         0.0000          0.0000

Example: TD_DFFT2CONV Call Using K_INTEGRAL

EXECUTE FUNCTION INTO VOLATILE ART(DFFT2CONV_RAW_OUT)
TD_DFFT2CONV(
     ART_SPEC(TABLE_NAME(DFFT2_HR_OUT)),
     FUNC_PARAMS(CONV(HR_TO_RAW),
        FREQ_STYLE(K_INTEGRAL)),
     OUTPUT_FMT(CONTENT(AMPL_PHASE_RADIANS)))
;

TD_DFFT2CONV Output

SELECT * FROM DFFT2_HR_OUT;

ID ROW_I COLUMN_I REAL_MAGNITUDE IMAG_MAGNITUDE
----------- ----------- ----------- ---------------------- ----------------------
33 -2 -2 0.00000000000000E 000 0.00000000000000E 000
33 -2 -1 0.00000000000000E 000 0.00000000000000E 000
33 -2 0 -8.00000000000000E 000 0.00000000000000E 000
33 -2 1 0.00000000000000E 000 0.00000000000000E 000
33 -2 2 0.00000000000000E 000 0.00000000000000E 000
33 -1 -2 0.00000000000000E 000 0.00000000000000E 000
33 -1 -1 0.00000000000000E 000 0.00000000000000E 000
33 -1 0 -8.00000000000000E 000 -8.00000000000000E 000
33 -1 1 0.00000000000000E 000 0.00000000000000E 000
33 -1 2 0.00000000000000E 000 0.00000000000000E 000
33 0 -2 -3.20000000000000E 001 0.00000000000000E 000
33 0 -1 -3.20000000000000E 001 -3.20000000000000E 001
33 0 0 1.36000000000000E 002 0.00000000000000E 000
33 0 1 -3.20000000000000E 001 3.20000000000000E 001
33 0 2 -3.20000000000000E 001 0.00000000000000E 000
33 1 -2 0.00000000000000E 000 0.00000000000000E 000
33 1 -1 0.00000000000000E 000 0.00000000000000E 000
33 1 0 -8.00000000000000E 000 8.00000000000000E 000
33 1 1 0.00000000000000E 000 0.00000000000000E 000
33 1 2 0.00000000000000E 000 0.00000000000000E 000
33 2 -2 0.00000000000000E 000 0.00000000000000E 000
33 2 -1 0.00000000000000E 000 0.00000000000000E 000
33 2 0 -8.00000000000000E 000 0.00000000000000E 000
33 2 1 0.00000000000000E 000 0.00000000000000E 000
33 2 2 0.00000000000000E 000 0.00000000000