Input
- InputTable: bank_web_clicks1, as in FrequentPaths Example 1: 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. Totally 15 patterns were found. |
This query returns the following table:
SELECT * FROM output5 ORDER BY 3 DESC, 2 DESC, 1;
pattern | support | length ---------------------------------------------------------------------+---------+-------- ACCOUNT SUMMARY;FUNDS TRANSFER;VIEW DEPOSIT DETAILS;ACCOUNT HISTORY | 2 | 4 ACCOUNT SUMMARY;FUNDS TRANSFER;ACCOUNT HISTORY | 2 | 3 ACCOUNT SUMMARY;FUNDS TRANSFER;VIEW DEPOSIT DETAILS | 2 | 3 ACCOUNT SUMMARY;VIEW DEPOSIT DETAILS;ACCOUNT HISTORY | 2 | 3 FUNDS TRANSFER;VIEW DEPOSIT DETAILS;ACCOUNT HISTORY | 2 | 3 ACCOUNT SUMMARY;ACCOUNT HISTORY | 2 | 2 ACCOUNT SUMMARY;FUNDS TRANSFER | 2 | 2 ACCOUNT SUMMARY;VIEW DEPOSIT DETAILS | 2 | 2 FUNDS TRANSFER;ACCOUNT HISTORY | 2 | 2 FUNDS TRANSFER;VIEW DEPOSIT DETAILS | 2 | 2 VIEW DEPOSIT DETAILS;ACCOUNT HISTORY | 2 | 2 ACCOUNT HISTORY | 2 | 1 ACCOUNT SUMMARY | 2 | 1 FUNDS TRANSFER | 2 | 1 VIEW DEPOSIT DETAILS | 2 | 1 (15 rows)