IDWT2D Example - Teradata Vantage

This example reconstructs the DWT2D Example input table.

Input

Input tables are DWT2D Example output:

• InputTable: dwt_coef_table
• MetaTable: dwt_meta_table

SQL Call

SELECT * FROM IDWT2D (
  ON dwt2d_coeftable AS InputTable
  ON dwt2d_metatable AS MetaTable
  OUT TABLE OutputTable (climate2d_reconstruct)
  USING
  InputColumns ('temp_f', 'pressure_mbar', 'dewpoint_f')
  SortColumn ('waveletid')
  PartitionColumns ('state')
) AS dt;

Output

IDwt2D finished successfully!

This query returns the following table:

SELECT * FROM climate2d_reconstruct ORDER BY state;