nPath Example 3: Find Paths to Checkout Page for Purchases Over $200 - 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 (nonoverlapping)
  Pattern ('A*.C+.A*')
  Symbols (productprice > 200 AND
          pagetype='checkout' AS C, true AS A)
  Result (FIRST(sessionid OF A) AS sessionid,
  Accumulate (pagetype OF ANY(A,C)) AS path,
    AVG (productprice OF ANY(A,C)) AS sum)
) AS dt;

Output