Input
- InputTable: bank_web_clicks1, as in FrequentPaths Example: ItemColumn
SQL Call
SELECT * FROM FrequentPaths( ON bank_web_clicks1 AS InputTable OUT TABLE OutputTable(output5) USING PartitionColumns('session_id') TimeColumn('datestamp') ItemColumn('page') PathFilters('STW(account summary) EDW(account history)') MinSupport(2) ) AS dt ;
Output
message --------------------------------- Finished. 15 patterns were found. SELECT CAST(pattern AS varchar(500)), support, length FROM output5 ORDER BY 3 DESC, 2 DESC; pattern support length ------------------------------------------------------------------- ------- ------ account summary;funds transfer;view deposit details;account history 2 4 funds transfer;view deposit details;account history 2 3 account summary;funds transfer;view deposit details 2 3 account summary;funds transfer;account history 2 3 account summary;view deposit details;account history 2 3 account summary;funds transfer 2 2 funds transfer;account history 2 2 account summary;view deposit details 2 2 view deposit details;account history 2 2 account summary;account history 2 2 funds transfer;view deposit details 2 2 account summary 2 1 account history 2 1 view deposit details 2 1 funds transfer 2 1
Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.