VARMAX Example 7: Existing Orders Table - Teradata Vantage

This example uses an existing orders table instead of a PDQ argument or TimeSeriesOrders call.

Input

• Data table: finance_data3, as in VARMAX Example 1: No Exogenous Model
• Orders table: orders_ex7

SQL Call

SELECT * FROM VARMAX (
  ON finance_data3 AS "data" PARTITION BY id ORDER BY period
  ON orders_ex7 AS orders PARTITION BY id
  USING
  ResponseColumns ('expenditure')
  PartitionColumns ('id')
  MaxIterNum (1000)
  "Method" ('ML')
) AS dt;

Output