Input
- xml_input1, as in XMLParser Example: Sibling and Sibling_Delimiter
SQL Call
SELECT * FROM XMLParser ( ON xml_input1 USING TextColumn ('xmldocument') Nodes ('temperature/read:type','storage/{used, total}') Sibling ('settopid:{type, length}','accountid') Ancestor ('setTopRpt') OutputColumnNodeID ('nid') MaxItemNum (1) Accumulate ('xid') ) AS dt;
Output
The output table has the node and sibling values of the specified ancestor, setTopRpt.
xid nid out_parent_node settopid settopid_type settopid_length accountid read read_type used total --- --- --------------- -------- ------------- --------------- --------- ---- ---------- ---- ----- 2 1 temperature ST789 string 5 8728 46 bigDecimal 2 2 storage ST789 string 5 8728 98 300
Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.