SELECT * FROM npath ( ON clicks PARTITION BY sessionid ORDER BY clicktime Mode ('nonoverlapping') Symbols (pagetype='home' AS H, pagetype='checkout' AS C, pagetype!='home' AND pagetype!='checkout' AS A) Pattern ('^H+.A*.C+$') Result ( FIRST (sessionid OF ANY (H, A, C)) AS sessionid, FIRST (clicktime OF H) AS firsthome, FIRST (clicktime OF C) AS firstcheckout, ACCUMULATE (productname OF ANY (H,A,C)) AS products_accumulate, COUNT (DISTINCT productname OF ANY(H,A,C)) AS count_distinct_products, ACCUMULATE (CDISTINCT productname OF ANY (H,A,C)) AS consecutive_distinct_products, ACCUMULATE (DISTINCT productname OF ANY (H,A,C)) AS distinct_products, NTH (productname, -1 OF ANY(H,A,C)) AS nth ) ) ORDER BY sessionid;