ExtractValue Syntax - Advanced SQL Engine - Teradata Database

DATASET Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
amv1590702100517.ditamap
dita:ditavalPath
amv1590702100517.ditaval
dita:id
B035-1198
lifecycle
previous
Product Category
Teradata Vantageā„¢
DATASET_expression.ExtractValue ('$dot_notation')

Syntax Elements

DATASET_expression
Any expression that evaluates to a DATASET data type.
dot_notation
All dot notation elements are supported, including the following new elements:
  • Recursive descent operator ( .. )
  • Wildcards ( * ) - both in reference to named and indexed items
  • Name/index lists ( [a,b,c] or [0,3,5] )
  • Name/index slices ([c] or [5])