TimeSeriesOrders Example 1: PartitionColumns - Teradata Vantage

Input

• milk_3, as in VARMAX Example 6: Orders Table with Two Time Series

SQL Call

SELECT * FROM TimeSeriesOrders (   
  ON milk_3 AS "data" PARTITION BY id_partition ORDER BY period ASC
  USING
  PartitionColumns ('id_partition')
  TimeColumns ('period')
  ResponseColumn ('milkpound')
) AS dt ORDER BY id_partition;

Output

The specified partition column, id_partition, appears in the output table.