SAX Example 4: Sliding Window, Character Output - Teradata Vantage

Input

• input: financial_data3, as in VARMAX Example 1: No Exogenous Model

SQL Call

SELECT * FROM SAX (
  ON finance_data3 AS "input" PARTITION BY id ORDER BY period
  USING
  TargetColumns ('expenditure', 'income', 'investment')
  TimeColumn ('period')
  OutputType ('characters') 
  WindowType ('global')
  Accumulate ('id')
) AS dt ORDER BY id;

Output