XPath (deprecated)

The node takes the XML Documents of the selected column and performs a XPath query on them. The node supports XPath 1.0.

XPath Examples

Consider the XML document:
<inventory>
<book year="1999">
<title>Harry Potter and the Sorcerer's Stone</title>
<author>J. K. Rowling</author>
</book>
<book year="2000">
<title>Harry Potter and the Chamber of Secrets</title>
<author>J. K. Rowling</author>
</book>
</inventory>

With the Return type "Node-Set" and the denoted XPath query you can get

• all books : //book
• all author element within book : //book/author
• the books from 1999 : //book[@year='1999']

With the Return type "String" you can get the value of the first year attribute with //@year . If you want all publishing dates you can use a flow of two XPath nodes and own Ungroup node. Use an XPath node with query //@year and return type "Node-Set" then the Ungroup node followed by an XPath with query //@year and return type "String".

You can find more examples at w3cschools.com .

Input ports

1. Type: Table
   Input Table
   Input table containing at least one XML column.

Output ports

1. Type: Table
   Output Table
   The input table with additional column containing the result of the XPath query.