nPath Function Results Example | Teradata Vantage - nPath Results Example: Hindi Input, ACCUMULATE DISTINCT and CDISTINCT - Analytics Database

Input

SQL Call

SELECT * FROM nPath (
  ON unicode_path PARTITION BY id
  USING
  Mode (NONOVERLAPPING)
  Pattern ('A*')
  Symbols (true AS A)
  Result (
    ACCUMULATE (DISTINCT event OF A DELIMITER ',  ' ) AS acc_result_distinct,
    ACCUMULATE (CDISTINCT event OF A DELIMITER ',  ' ) AS acc_result_cdistinct
  )
) AS dt;

Output