This example outputs the attributes as if they were nodes.
Input
- xmlrelation_input, as in XMLRelation Example 1: OutputType ('fulldata')
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 |