nPath Example 5: Find First Product with Multiple Referrers in Any Session - 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 ('REFERRER{2,}')
  Symbols (referrer IS NOT NULL AS REFERRER)
  Result (FIRST(sessionid OF REFERRER) AS sessionid,
          FIRST(productname OF REFERRER) AS product)
) AS dt;

Output