TD_RowNormalizeTransform Example | Teradata Vantage - TD_RowNormalizeTransform Example - Teradata® Database

• InputTable: input_table, as in TD_RowNormalizeFit Example
• FitTable: fit_output, output by TD_RowNormalizeFit Example

SQL Call

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

Output

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