1.0 - 8.00 - nPath Example 7: Find Data for Sessions that Checked at Least 3 Products - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)

Modify the SQL call in nPath Example 6: Find Data for Sessions that Checked 3-6 Products to find sessions where the user checked at least three products by changing the Pattern argument.

Input

SQL Call

SELECT * FROM nPath@coprocessor (
  ON aggregate_clicks PARTITION BY sessionid ORDER BY clicktime
  USING
  Mode (nonoverlapping)
  Pattern ('H+.D*.C{3,}.D')
  Symbols (pagetype = 'home' AS H, pagetype='checkout' AS C,
          pagetype <>'home' AND pagetype <>'checkout' AS D)
  Result (FIRST(sessionid OF C) AS sessionid,
    max_choose (productprice, productname OF C) AS
    most_expensive_product,
    MAX (productprice OF C) AS max_price,
    min_choose (productprice, productname OF C) AS
    least_expensive_product,
    MIN (productprice OF C) AS min_price)
) AS dt;

Output

sessionid most_expensive_product max_price least_expensive_product min_price
5 cellphones 600 bookcases 150