Purpose - Teradata® Database

Database Analytic Functions

Product
Teradata® Database
Release Number
16.10
15.10
Published
November 2017
Language
English (United States)
Last Update
2018-05-10
dita:mapPath
hoj1499019223447.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-1206
lifecycle
previous
Product Category
Teradata® Database

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