TD_RowNormalizeTransformの例 - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine分析関数

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
2021年7月
ft:locale
ja-JP
ft:lastEdition
2021-09-23
dita:mapPath
ja-JP/wnd1589838592459.ditamap
dita:ditavalPath
ja-JP/ayr1485454803741.ditaval
dita:id
B035-1206
Product Category
Software
Teradata Vantage

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