TD_RowNormalizeTransformの例 - Advanced SQL Engine - Teradata Database

• InputTable: input_table (TD_RowNormalizeFitの例と同様)
• FitTable: fit_output (TD_RowNormalizeFitの例によって出力)

SQL呼び出し

SELECT * FROM TD_RowNormalizeTransform (
  ON input_table AS InputTable
  ON fit_output AS FitTable DIMENSION
  USING
  Accumulate ('id')
) AS dt;

出力

id    x       y             
 -- ------- ------
  1  0.00   100.00
  2 75.00   100.00
  3 41.66   100.00
  4 29.16   100.00