This example finds the first product with multiple referrers in any session.
Input
- aggregate_clicks, as in LAG and LEAD Expressions Example: First and Most Expensive Purchases (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
sessionid product --------- ---------- 5 appliances 4 tables 2 tables 3 bookcases 1 envelopes
Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.