16.10 - Purpose - Teradata Database

Teradata Analytic Functions

prodname
Teradata Database
vrm_release
15.10
16.10
created_date
November 2017
category
Programming Reference
featnum
B035-1206-151K

The nPath® function matches specified patterns in a sequence of rows from one or more input tables and extracts information from the matched rows.



Typical nPath uses are:
  • Categorizing entities based on observed patterns; for example, distinguishing “loyal customers” from “price-sensitive shoppers.”
  • Selecting relevant data from a data set and then inputting it to another function or a third-party data graph generator, such as the application that produced the following figure.
    Sankey Diagram of Teradata nPath Output