1.0 - 8.00 - XMLRelation Example 4: Output Attributes as Nodes - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)

This example outputs the attributes as if they were nodes.

Input

SQL Call

SELECT * FROM XMLRelation (
  ON xmlrelation_input
  USING
  TextColumn ('xmldocument')
  DocIDColumns ('xid')
  MaxDepth (3)
  AttributeAsNode ('true') 
) AS dt ORDER BY 1,2;

Output

The element column contains both actual nodes and attributes that are output as nodes. For the latter, the attributes column contains a tilde (~).

xid out_nodeid element attributes value_col d0id d1id d2id d3id
1 1 School name=UCLA   1      
1 2 name ~ UCLA 1 2    
1 3 Dept name=EE   1 3    
1 4 name ~ EE 1 3 4  
1 5 Class A=grad,B=undergrad   1 3 5  
1 6 A ~ grad 1 3 5 6
1 7 B ~ undergrad 1 3 5 7
1 8 Student   Harry 1 3 5 8
1 9 Grade   A+ 1 3 5 9