ScaleByPartition Example - Teradata Vantage

This example scales the sequences in each partition independently.

Input

• scale_housing, as in Scale Example 1: ScaleMethod ('midrange'), which is partitioned by the column types

SQL Call

SELECT * FROM ScaleByPartition (
  ON scale_housing PARTITION BY types
  USING
  TargetColumns ('[2:6]')
  ScaleMethod ('maxabs')
  Accumulate ('types', 'id')
) AS dt ORDER BY 1 desc,2;

Output