17.10 - teradata_group Attribute - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - XML Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1140-171K
Language
English (United States)

Use the teradata_group attribute in the stylesheet to annotate the result structure with information regarding which fields comprise repeating groups, specifying the key fields on which grouping will be done. To specify the grouping behavior, place a teradata_group attribute under which the grouping will happen and assign it a value on which the grouping will be done at that level.

In the previous Purchase Order example, the fields that comprise repeating groups are represented by the Customer, Order, and Item elements.