{"title":"XPath","nodeType":"Manipulator","id":"*dTIN1LNlL6w1s7MX","factoryName":"org.knime.xml.node.xpath2.XPathNodeFactory","factoryId":"org.knime.xml.node.xpath2.XPathNodeFactory","path":["Structured Data","XML"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"

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

XPath Syntax

\n \t\t \n

Selection Nodes

\n \t\t \n ExpressionDescriptionnodenameSelects all nodes with the name "nodename"/Selects from the root node.//Selects nodes in the document from the current node that match the selection no matter where they are.Selects the current node..Selects the parent of the current node@Selects attributes\n \t\t\t\n\t\t\t\n

Predicates

\n \t\t\t\n Path ExpressionResult/bookstore/book[1]Selects the first book element that is the child of the bookstore element./bookstore/book[last()]Selects the last book element that is the child of the bookstore element/bookstore/book[last()-1]Selects the last but one book element that is the child of the bookstore element/bookstore/book[position()<3]Selects the first two book elements that are children of the bookstore element//title[@lang]Selects all the title elements that have an attribute named lang//title[@lang='en']Selects all the title elements that have a "lang" attribute with a value of "en"/bookstore/book[price>35.00]Selects all the book elements of the bookstore element that have a price element with a value greater than 35.00/bookstore/book[price>35.00]/titleSelects all the title elements of the book elements of the bookstore element that have a price element with a value greater than 35.00\n \t\t\n\t\t\t\n

Syntax description from w3cschools.com .

\n \n \n \n

Hint for streaming: Node can only be executed in real streamed fashion if every single XPath query is configured as follow (see XPath Query Settings):\n
\n The column names are fixed (i.e. select 'new column name') and either 'Single Cell', 'Collection Cell', or 'Multiple Rows' are selected as 'Multiple tag option'.

\n \t\t\n \n ","shortDescription":"Performs XPath queries on a XML column.","keywords":["xml parse"],"deprecated":false,"streamable":true,"tags":["Structured Data","XML","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyhpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMTExIDc5LjE1ODMyNSwgMjAxNS8wOS8xMC0wMToxMDoyMCAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6OTA3QjM5MDVGRkQ1MTFFNUE0NjdERjk5NTcwREEwQjEiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6OTA3QjM5MDRGRkQ1MTFFNUE0NjdERjk5NTcwREEwQjEiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDoyREY1MUIzRDVFM0YxMUU1OTM1M0I0OTExN0ZBRjYyRiIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDoyREY1MUIzRTVFM0YxMUU1OTM1M0I0OTExN0ZBRjYyRiIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pl/+kb8AAAHvSURBVHjaYmRAAsICwkJMzCw1DAyM4f/+/pZiZGT8xcTMevrvn19dbz+83QRS8///f2QtDIxImhWYWdhOcEpIM4k7+N7n19B/9/fHV+b3549JPN29XhmoZOarV8+KsBoA1MzIzMZ+UUBZW1A5tfwCAxMTWFWUrpzazdcf3xy7cOXH1f4qyz8/f8S/ef9mDbIBTFDa7v/ffxry0dlXYJpB4OuvP79iTZUtjXS0WCUcfO8BvVPJgAZgBpjxyCq+Y+Hh+40sufHmsweXn71/oCchIManZfAGGC4G6AawQOm//xkZGbCBxRceXOdgYWJi/P+fC6jmHy4XHP3y+J7gny+fWNEV/Pr7/9+nn3//vAMGJgsz6wWsBgCj6CQLC9vFB6tmajOihTIIfLl7jf/lkV1K//79bUGXQ45GEyB1mk9B7aW4k989XgX1T7+/fmJ5d+qA9PNDO5SY2NnbXz572IArGpmB1D5wbDAyPgEmpr///v6RYWJk/srExnbs749vbUBXHsaWkGC27wLi/yA8ZeLk/yDw5cuX/39+/f5PCIA0Z8M083LxQgTBFiFouGIs4qBonAhyBR8fH0NMfAwDMP2jOBPGZ8QRzSAXfAPiPxfOnYeb3tDQgNVGbC5gRLLtP7JtyDQu14DZyAYwkAEAAgwAHZlJEsuB10EAAAAASUVORK5CYII=","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input Table","description":"Input table containing at least one XML column."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Output Table","description":"The input table with additional columns containing the result of the XPath queries."}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Settings","fields":[{"name":"XML column","description":"The column containing the XML cells.","optional":false},{"name":"Remove source column","description":"Check when the source column should not show up in the output table.","optional":false},{"name":"XPath summary","description":"A summary of all defined XPath queries.","optional":false},{"name":"Add XPath","description":"Opens a new dialog with the XPath query set XPath query of the selected XML element.","optional":false},{"name":"Eidt XPath","description":"Edit a selected XPath query of the summary table.","optional":false},{"name":"Remove XPath","description":"Remove a selected XPath query of the summary table.","optional":false},{"name":"XML-Cell Preview","description":"Preview of the first not missing XML-Cell of the selected XML column. If a XML element is selected a right click can be performed to add a new XPath query.\n
\nNote:Only the first 2000 lines of the input XML cell are displayed.","optional":false}]},{"sectionName":"Namespace","fields":[{"name":"Namespaces","description":"The prefixes and the namespaces used in the XPath query. For the example when querying XHTML documents with the XPath Query:\n
\n//pre:h1\n
\nthe following namespace must be defined:\n
\nPrefix: pre\n
\nNamespace: http://www.w3.org/1999/xhtml\n
\nNote:The namespaces are collected automatically.","optional":false},{"name":"Incorporate namespace of the root element.","description":"

This option is useful when you do not have the default namespace of your document at hand.

\n

If checked, the namespace of the root element is added to the Namespaces table during runtime. Please define a prefix for this namespace in Prefix of root's namespace .

\n

For the example of XHTML documents the namespace of the root element is http://www.w3.org/1999/xhtml so that with the root's prefix of pre you can leave the Namespaces table empty.

","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.12.0.v202604300901","bundleName":"KNIME XML","bundleSymbolicName":"org.knime.xml","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.xml","featureName":"KNIME XML-Processing","featureVersion":"5.12.0.v202604300910","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*Uj1RwEYxAESCvnlT"},"frequentSuccessors":[{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.18310858765081617},{"id":"*dTIN1LNlL6w1s7MX","factoryName":"org.knime.xml.node.xpath2.XPathNodeFactory","probability":0.12207239176721078},{"id":"*jd2U-FYTI8jCbQls","factoryName":"org.knime.base.node.preproc.filter.row.RowFilterNodeFactory","probability":0.06458481192334989},{"id":"*aItro4n6xSMUuxg-","factoryName":"org.knime.base.node.preproc.ungroup.UngroupNodeFactory","probability":0.043293115684882894},{"id":"*eOn8ibZnxIkY7XhT","factoryName":"org.knime.base.node.preproc.stringmanipulation.StringManipulationNodeFactory","probability":0.035486160397444996},{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.035486160397444996},{"id":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.0262597586941093},{"id":"*AApA5VHd41CVDe7u","factoryName":"org.knime.base.node.meta.looper.LoopEndNodeFactory","probability":0.0234208658623137},{"id":"*Oy714gpoifm4PiOZ","factoryName":"org.knime.base.node.io.csvwriter.CSVWriterNodeFactory","probability":0.0234208658623137},{"id":"*JiJhJpgkWWuOfG2s","factoryName":"org.knime.ext.poi2.node.write2.XLSWriter2NodeFactory","probability":0.0198722498225692}]}