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 .