IFFT Example: 3D Signal | Teradata Vantage - IFFT Example: 3D Signal - Teradata Vantage

In this example, the signal is one-dimensional (3D).

Input

• InputTable: fft_output3, output by FFT Example: 3D Signal

SQL Call

CREATE MULTISET TABLE ifft_output_table3 AS (
  SELECT * FROM IFFT (
    ON fft_output3 AS inputtable PARTITION BY id_0 ORDER BY timestep
    USING
    TargetColumns ('real_value1', 'imag_value1')
    Dimensions (3)
    RealValuedSignal ('false')
  ) AS dt
) WITH DATA;

Output

This query returns the following table:

SELECT * FROM ifft_output_table3;

 id_0 timestep real_real_value1 imag_real_value1 
 ---- -------- ---------------- ---------------- 
    1        3              3.0              0.0
    1        5              5.0              0.0
    1        6              6.0              0.0
    1        7              7.0              0.0
    1        8              8.0              0.0
    1        4              4.0              0.0
    1        2              2.0              0.0
    1        1              1.0              0.0

Download a zip file of all examples and a SQL script file that creates their input tables.