nPath Function | Teradata Vantage - nPath - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantageā„¢

The nPath function scans a set of rows, looking for patterns that you specify. For each set of input rows that matches the pattern, nPath produces a single output row. The function provides a flexible pattern-matching capability that lets you specify complex patterns in the input data and define the values that are output for each matched input set.



nPath is useful when your goal is to identify the paths that lead to an outcome. For example, you can use nPath to analyze:

  • Web site click data, to identify paths that lead to sales over a specified amount
  • Sensor data from industrial processes, to identify paths to poor product quality
  • Healthcare records of individual patients, to identify paths that indicate that patients are at risk of developing conditions such as heart disease or diabetes
  • Financial data for individuals, to identify paths that provide information about credit or fraud risks
Sankey Diagram of Analytics Database nPath Output
Sankey diagram of output of Analytics Database function nPath
  • This function requires the UTF8 client character set for UNICODE data.
  • This function does not support UNICODE input/output data for ACCUMULATE function of Result syntax element.
  • This function does not support UNICODE characters for Pattern syntax element and symbol in Symbols syntax element.
  • This function does not support Pass Through Characters (PTCs).

    For information about PTCs, see International Character Set Support, B035-1125.

  • This function does not support KanjiSJIS or Graphic data types.
  • When used with this function, the ORDER BY clause supports only ASCII collation.
  • When used with this function, the PARTITION BY clause assumes column names are in Normalization Form C (NFC).