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) DELIMITER '*') AS products_accumulate, ACCUMULATE (CDISTINCT productname OF ANY (H,A,C) DELIMITER '$$') AS cde_dup_products, ACCUMULATE (DISTINCT productname OF ANY (H,A,C)) AS de_dup_products ) ) ORDER BY sessionid;