nPath Example 4: Mode (overlapping) - Teradata Vantage

Input

• aggregate_clicks, as in LAG and LEAD Expressions Example 2 (under nPath Symbols)

SQL Call

SELECT * FROM nPath@coprocessor (
  ON aggregate_clicks PARTITION BY sessionid ORDER BY clicktime
  USING
  Mode (overlapping)
  Pattern ('A.A')
  Symbols (TRUE AS A)
  Result (FIRST(sessionid OF A) AS sessionid,
  Accumulate (pagetype OF A) AS path)
) AS dt;

Output