PathAnalyzer Example - Teradata Vantage

Input

• InputTable: clickstream1, as in PathGenerator Example

SQL Call

SELECT * FROM PathAnalyzer (
  ON clickstream1 AS InputTable
  OUT TABLE OutputTable (path_output)
  USING
  SeqColumn ('path')
  CountColumn ('cnt')
  HashCode ('false')
  Delimiter (',')
) AS dt;

Output

Query executed successfully. Output is stored in the table specified in  OutputTable argument.

The output table is the same as the PathStart Example output.