Input
- InputTable: bank_web_clicks1, as in FrequentPaths Example: ItemColumn
SQL Call
SELECT * FROM FrequentPaths( ON bank_web_clicks1 AS InputTable OUT TABLE OutputTable(output4) OUT TABLE SeqPatternTable(sp_table) USING PartitionColumns('session_id') TimeColumn('datestamp') ItemColumn('page') MinSupport(2) ) AS dt;
Output
The output table "output4" is identical to the output table shown in FrequentPaths Example: ItemColumn, "output1". The SequencePatternTable can be shown with the following query: SELECT session_id, CAST(pattern AS varchar(500)) FROM sp_table ORDER BY 1; session_id pattern ---------- ------------------------------------------------------------------------------- 0 account summary;account summary;view deposit details 0 funds transfer;account summary 0 account summary;account history;funds transfer 0 account history;funds transfer 0 account summary;account history;view deposit details 0 account summary;funds transfer;view deposit details 0 funds transfer;view deposit details 0 account history;view deposit details 0 account summary;funds transfer;account summary 0 account history;account summary 0 account summary;funds transfer 0 account history 0 account summary;view deposit details 0 account summary;account history;account summary 0 funds transfer 0 account summary 0 account summary;account summary 0 account summary;account history 0 view deposit details 0 account summary;faq;view deposit details 0 faq;account summary;view deposit details 0 faq;funds transfer;account summary 0 faq;account history 0 faq;account summary 0 account summary;faq;account summary 0 account summary;faq 0 faq 0 account summary;faq;funds transfer 0 faq;account history;account summary 0 faq;account history;view deposit details 0 faq;funds transfer 0 account summary;faq;account history 0 account summary;faq;funds transfer;account summary 0 faq;view deposit details 0 account summary;faq;account history;view deposit details 0 account summary;faq;funds transfer;view deposit details 0 account summary;faq;account summary;view deposit details 0 faq;funds transfer;view deposit details 0 account summary;faq;account history;account summary 1 account summary 1 funds transfer;account summary 1 account history;account summary 1 account history;account history 1 view deposit details 1 account summary;view deposit details 1 account summary;account summary;account summary 1 account summary;view deposit details;account history 1 funds transfer;view deposit details 1 account summary;funds transfer;account history 1 account summary;account history;view deposit details 1 view deposit details;account history 1 account summary;account summary;account history;account summary 1 account history;account summary;account history 1 funds transfer;view deposit details;account history 1 account summary;funds transfer;account summary 1 account summary;account summary;account summary;account summary 1 funds transfer;account history 1 account history 1 account summary;funds transfer;view deposit details;account history 1 account history;view deposit details 1 account summary;account history;account summary;account history 1 account summary;account history;account summary 1 account summary;account history 1 account summary;account summary 1 account summary;funds transfer;view deposit details 1 account summary;account history;account history 1 funds transfer 1 account summary;funds transfer 1 account summary;account summary;view deposit details 1 account summary;account summary;account history 1 account summary;account summary;funds transfer 1 account summary;account summary;account summary;account history 1 account summary;account summary;account summary;account history;account summary 1 account summary;account summary;account summary;funds transfer 1 account summary;faq;view deposit details 1 account summary;faq;funds transfer;view deposit details 1 account summary;faq;funds transfer 1 account summary;faq;account summary 1 account summary;faq;account summary;account summary 1 faq;account summary 1 account summary;faq 1 account summary;account summary;faq;account summary;account summary 1 account summary;faq;funds transfer;account summary 1 account summary;account summary;faq;account summary 1 account summary;faq;account summary;view deposit details 1 account summary;account summary;faq 1 account summary;faq;account history;account summary 1 faq 1 faq;view deposit details 1 faq;account summary;account summary 1 faq;account history;view deposit details 1 faq;funds transfer 1 faq;account history 1 faq;funds transfer;account summary 1 faq;funds transfer;view deposit details 1 faq;account history;account summary 1 account summary;faq;account history;view deposit details 1 account summary;faq;account history 1 faq;account summary;view deposit details 2 faq;faq 2 account history;funds transfer 2 account history 2 account summary;account history;account summary 2 account summary;funds transfer 2 account summary;account summary;account history 2 account summary;account summary;account summary;funds transfer 2 account summary;account summary;account summary;account history;account summary 2 account summary;account summary;account summary 2 account history;account summary 2 account summary;faq;faq 2 account summary;account history;funds transfer 2 account summary 2 account summary;account summary;funds transfer 2 account summary;account summary;account history;account summary 2 account summary;account summary;account summary;account summary 2 account summary;account history 2 funds transfer 2 account summary;account summary;account summary;account history 2 account summary;account summary 2 faq 2 account history;account summary;faq 2 account summary;account history;faq 2 account summary;account summary;faq 2 account history;faq 2 account summary;faq 2 account summary;account history;account summary;faq 2 account summary;account summary;account history;faq 3 account summary;account history;account history 3 account summary;account history;account summary 3 account summary 3 account history;account summary;account history 3 account history;account history 3 account history;account summary 3 account history 3 account summary;account summary;account summary;account summary 3 account summary;account summary;account history;account summary 3 account summary;account summary 3 account summary;account history;account summary;account history 3 account summary;account summary;account summary 3 account summary;account history 3 account summary;account summary;account history 3 account summary;account summary;faq;account summary 3 account summary;account summary;account history;faq 3 faq;account summary;account summary 3 faq 3 account history;account summary;faq 3 account summary;account history;account summary;faq 3 account summary;faq;account summary 3 account summary;account summary;faq;account summary;account summary 3 account summary;account summary;faq 3 account summary;account history;faq 3 faq;account summary 3 account history;faq 3 account summary;faq;account summary;account summary 3 account summary;faq 4 faq;faq 4 account summary;view deposit details 4 account summary 4 view deposit details 4 account summary;faq;faq 4 account summary;faq;view deposit details 4 faq;view deposit details 4 faq 4 account summary;faq 5 view deposit details 5 account history 5 view deposit details;account history 5 account summary;account history 5 account summary;view deposit details;account history 5 funds transfer;account history 5 funds transfer 5 funds transfer;view deposit details 5 account summary;funds transfer;account history 5 account summary;funds transfer;view deposit details;account history 5 funds transfer;view deposit details;account history 5 account summary;view deposit details 5 account summary;funds transfer;view deposit details 5 account summary;funds transfer 5 account summary
(Row order can vary.)
Download a zip file of all examples and a SQL script file that creates their input tables.