XMLRelation Example 4: Output Attributes as Nodes - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.00
1.0
Published
May 2019
Language
English (United States)
Last Update
2019-11-22
dita:mapPath
blj1506016597986.ditamap
dita:ditavalPath
blj1506016597986.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantage™

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