The node takes the XML Documents of the selected column and
performs XPath queries on them. The node supports XPath 1.0.
XPath Syntax
Selection Nodes
| Expression | Description |
|---|---|
| nodename | Selects 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 |
Predicates
| Path Expression | Result |
|---|---|
| /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]/title | Selects all the title elements of the book elements of the bookstore element that have a price element with a value greater than 35.00 |
Syntax description from w3cschools.com.
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):
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'.
Options
Settings
Namespace
Popular Successors
- XPath10 %
- Column Filter7 %
- Concatenate4 %
Row Filter (deprecated)4 %Cell Splitter3 %- Joiner3 %
- String Manipulation3 %
- Ungroup2 %
String To Number2 %- Excel Writer2 %
- GroupBy2 %
- Loop End1 %
- HTML Parser1 %
Table Row to Variable1 %- Cell Splitter1 %
- XML to JSON< 1 %
- Column Expressions< 1 %
Excel Writer (XLS)< 1 %XLS Writer< 1 %- String to JSON< 1 %
- Group Loop Start< 1 %
Row Splitter (deprecated)< 1 %Strings To Document< 1 %- Regex Extractor< 1 %
Variable to Table Column< 1 %Excel Sheet Appender (XLS)< 1 %- String Manipulation (Multi Column)< 1 %
- Rule-based Row Splitter< 1 %
- CSV Writer< 1 %
- Webpage Retriever< 1 %
- Rule Engine< 1 %
- Java Snippet< 1 %
- Duplicate Row Filter< 1 %
- Counter Generation< 1 %
- Column List Loop Start< 1 %
- Column Appender< 1 %
- String to Number< 1 %
- Column Aggregator< 1 %
- Column Resorter< 1 %
- Missing Value< 1 %
- Table Manipulator< 1 %
- Column Splitter< 1 %
- Table Transposer< 1 %
- Rule-based Row Filter< 1 %
- Statistics< 1 %
Table to PDF< 1 %- Generic Web Service Client< 1 %
- Document Viewer< 1 %
- Variable Condition Loop End< 1 %
- Constant Value Column< 1 %
- Data to Report (BIRT)< 1 %
- HTTP Retriever< 1 %
Database Table Creator< 1 %- Reference Row Filter< 1 %
- Shuffle< 1 %
- String Replacer< 1 %
- Web Page Content Extractor< 1 %
- Chunk Loop Start< 1 %
Recursive Loop Start< 1 %- Interactive Pie chart (legacy)< 1 %
- JSON to XML< 1 %
- XML Row Combiner< 1 %
- HTML Node to Text< 1 %
CSV Writer< 1 %- Table Creator< 1 %
- Table View (JavaScript)< 1 %
- JSON Writer< 1 %
XPath< 1 %- Variable to Table Column< 1 %
- Pivot< 1 %
- Timer Info< 1 %
- Interactive Histogram (legacy)< 1 %
- XML Column Combiner< 1 %
- URL Extractor< 1 %
- Open in Python< 1 %
- URL to File Path< 1 %
- Table Column to Variable< 1 %
Loop End (2 ports)< 1 %Loop End (Column Append)< 1 %- Naive Bayes Predictor< 1 %
Cell Replacer< 1 %- Double to Integer< 1 %
Joiner< 1 %- Table Difference Finder< 1 %
Excel Sheet Appender (XLS)< 1 %- Markup Tag Filter< 1 %
- Columns to JSON< 1 %
Extract Date&Time Fields< 1 %- String to XML< 1 %
XML Writer< 1 %- Date Extractor< 1 %
- Collection to String< 1 %
- String to Table< 1 %
- Table Row to Variable< 1 %
- Read Images< 1 %
- Auto-Binner< 1 %
- Number to String< 1 %
- Column Renamer (Dictionary)< 1 %
- Extract Table Dimension< 1 %
- Table View< 1 %
- DB Insert< 1 %
- DB Writer< 1 %
- Java IF (Table)< 1 %
- Table to JSON< 1 %
- XML Writer< 1 %
- RDKit From InChI< 1 %
- Extract Attribute< 1 %
- Find Elements< 1 %
- Split Collection Column< 1 %
- Wait...< 1 %
- Catch Errors (Data Ports)< 1 %
- ARFF Writer< 1 %
Loop End< 1 %Concatenate (Optional in)< 1 %- Case Converter< 1 %
- Cell Splitter By Position< 1 %
- Column Auto Type Cast< 1 %
- Column Combiner< 1 %
Column Appender< 1 %- Cross Joiner< 1 %
- Extract Missing Value Cause< 1 %
- Missing Value Column Filter< 1 %
- Reference Row Splitter< 1 %
- String to Number (PMML)< 1 %
- XML to PMML< 1 %
- RowID< 1 %
- Row Sampling< 1 %
- Interactive Table (legacy)< 1 %
- Molecule Type Cast< 1 %
- Java Snippet (simple)< 1 %
- Java Snippet Row Splitter< 1 %
- RSS Feed Reader< 1 %
- Path to String< 1 %
- String to Path< 1 %
- Column Filter (legacy)< 1 %
- Table Editor (JavaScript)< 1 %
- JSON Path< 1 %
Python Script (2⇒1)< 1 %- R Snippet< 1 %
- String to Date&Time< 1 %
- String to Date/Time (legacy)< 1 %
- RDKit From Molecule< 1 %
- URL Domain Extractor< 1 %
Find Elements< 1 %- Quit WebDriver< 1 %
Table Extractor< 1 %- Wait< 1 %
- PDB Describe Heterogens< 1 %
- Combine Columns by Header< 1 %
- Binary Objects to Strings< 1 %
- Strings to Binary Objects< 1 %
- String to URI< 1 %
- Table Writer< 1 %
Table Writer< 1 %- Loop End (Column Append)< 1 %
Counting Loop Start< 1 %- Recursive Loop End< 1 %
Recursive Loop End< 1 %- Recursive Loop Start< 1 %
- Table Row to Variable Loop Start< 1 %
Variable Loop End< 1 %- RProp MLP Learner< 1 %
- String to SVG< 1 %
- Column Renamer< 1 %
- Column Name Extractor< 1 %
- Column to Grid< 1 %
- Edit Nominal Domain< 1 %
- Nominal Value Row Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Partitioning< 1 %
- Column Filter (PMML)< 1 %
- String Splitter (Regex)< 1 %
Column Rename< 1 %- Number Rounder< 1 %
- Sorter< 1 %
- Unpivot< 1 %
- Renderer to Image< 1 %
- CASE Switch End< 1 %
- Empty Table Switch< 1 %
- End IF< 1 %
- Extract Table Spec< 1 %
- Scatter Matrix (legacy)< 1 %
- Similarity Search< 1 %
- Pie/Donut Chart (JavaScript)< 1 %
- Math Formula< 1 %
- Math Formula (Multi Column)< 1 %
- Table Indexer< 1 %
Excel Writer (XLS)< 1 %- RegEx Filter< 1 %
- Bag Of Words Creator< 1 %
- Strings to Document< 1 %
- Transfer Files (Table)< 1 %
- Nominal Row Filter Configuration< 1 %
- Scatter Plot (JavaScript)< 1 %
- JSON to Table< 1 %
Python Script (1⇒2)< 1 %- Python Script (legacy)< 1 %
- GET Request< 1 %
- Table Difference Checker< 1 %
- Column to XML< 1 %
- XSLT< 1 %
Regex Extractor< 1 %- HTTP Result Data Extractor< 1 %
- Multipart Encoded HTTP Entity Creator< 1 %
Extract Outer/InnerHTML< 1 %Execute JavaScript< 1 %- Create Collection Column< 1 %
- Extract Variables (Data)< 1 %
Database Update< 1 %- Expand Bit Vector< 1 %
- Column Merger< 1 %
- Column Rename (Regex)< 1 %
- Equal Size Sampling< 1 %
- Parallel Chunk End< 1 %
Table to HTML< 1 %- OpenBabel< 1 %
- Doc2Vec Learner (legacy)< 1 %
- Replacer< 1 %
Stop Word Filter< 1 %- String to Term< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- Line Plot (JavaScript)< 1 %
- Object Inserter< 1 %
- Time Difference (legacy)< 1 %
- String Similarity< 1 %
- URL Resolver< 1 %
- Form Encoded HTTP Entity Creator< 1 %
Table Extractor< 1 %- CIR< 1 %
- Reaxys Substances< 1 %
- Table Row To Variable Run-for-time Loop Start< 1 %
- Breakpoint< 1 %
Variable to Table Column< 1 %Parameterized Database Query< 1 %Variable Condition Loop End< 1 %- k-Means< 1 %
- PMML Simple Regression Tree Predictor< 1 %
Number To String< 1 %- Reference Column Filter< 1 %
- Interactive HiLite Collector< 1 %
- Normalizer< 1 %
- Missing Value (Apply)< 1 %
- String Manipulation (Variable)< 1 %
- Top k Row Filter< 1 %
- Value Counter< 1 %
- Rule Engine (Dictionary)< 1 %
- Data Explorer< 1 %
- Histogram (legacy)< 1 %
- Size Manager< 1 %
- String Distances< 1 %
- k-Medoids< 1 %
- Bar Chart (JFreeChart)< 1 %
- Index Query< 1 %
XLS Sheet Appender< 1 %- Topic Extractor (Parallel LDA)< 1 %
Dictionary tagger< 1 %- POS Tagger< 1 %
- Document Data Extractor< 1 %
- Tag Cloud< 1 %
- Tile View (JavaScript)< 1 %
- Date&Time Difference< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Web Log Reader< 1 %
- XML Row Combine and Write< 1 %
- Text Classifier Predictor< 1 %
- Google Address Geocoder< 1 %
- Reaction Splitter< 1 %
- Benchmark End< 1 %
- Collection Size< 1 %
- SMARTSViewer< 1 %
- XLS Coloured Writer< 1 %
- Extract URI Info< 1 %
Table Row to Variable< 1 %- Variable to Credentials< 1 %
Database Writer< 1 %Generic Loop Start< 1 %- Lag Column< 1 %
- Linear Correlation< 1 %
Column Filter< 1 %- Subset Matcher< 1 %
- Reference Column Resorter< 1 %
String Replace (Dictionary)< 1 %CASE Switch Data (End)< 1 %- HiLite Table (legacy)< 1 %
- Line Plot (legacy)< 1 %
Color Appender< 1 %- Color Manager< 1 %
- Parallel Chunk Start< 1 %
- Term Co-Occurrence Counter< 1 %
- Keygraph Keyword Extractor< 1 %
- Case Converter< 1 %
- Dictionary Replacer< 1 %
- Dictionary Tagger< 1 %
- Document Vector< 1 %
Column Filter Configuration< 1 %- Date&Time Configuration< 1 %
- R View (Table)< 1 %
- Date&Time Part Extractor< 1 %
- Modify Date< 1 %
- Modify Time Zone< 1 %
- Date/Time Shift (legacy)< 1 %
- Moving Aggregator< 1 %
Table to HTML String< 1 %- Text Classifier Learner< 1 %
- Latitude/Longitude to Coordinate< 1 %
- URL Normalizer< 1 %
HTTP Retriever< 1 %Web Searcher< 1 %Extract Attribute< 1 %Extract CSS Property< 1 %- InChi< 1 %
- Dense To Sparse< 1 %
IF Switch (Flow Variable Value)< 1 %Loop End (3 ports)< 1 %- Timed Loop End (1 port)< 1 %
- Run Garbage Collector< 1 %
- Uniquify IDs< 1 %
- Set To List< 1 %
- URL Decode< 1 %
- URL Encode< 1 %
- Create Well Position< 1 %
- Split Columns by Header< 1 %
- Plate Heatmap Viewer< 1 %
Python Snippet< 1 %- MolConverter< 1 %
- 2D/3D Scatterplot< 1 %
- File Meta Info (legacy)< 1 %
- URI to String< 1 %
- Active Branch Inverter< 1 %
- Inject Variables (Data)< 1 %
Table Column to Variable< 1 %Table Column to Variable< 1 %Table Row To Variable Loop Start< 1 %Variable to Table Row< 1 %Database Connector< 1 %- Counting Loop Start< 1 %
- Generic Loop Start< 1 %
Naive Bayes Predictor< 1 %- PNN Predictor< 1 %
- Decision Tree Learner< 1 %
- Regression Predictor< 1 %
- Add Empty Rows< 1 %
- Many to One< 1 %
- One to Many< 1 %
- Table Validator< 1 %
Double To Int< 1 %- Filter Apply< 1 %
- Row Filter (Labs)< 1 %
- Denormalizer< 1 %
- Many to One (PMML)< 1 %
- Denormalizer (PMML)< 1 %
- Rank< 1 %
- Set Operator< 1 %
- Rule Engine Variable< 1 %
- Ruleset Editor< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
- Cronbach Alpha< 1 %
CASE Switch Variable (End)< 1 %- IF Switch< 1 %
CASE Switch Data (Start)< 1 %- Global Timer Info< 1 %
Merge Variables< 1 %- Send Email< 1 %
- Pie chart (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
Parquet Writer< 1 %- Spark Pivot< 1 %
- SDF Writer< 1 %
- MySQL Connector< 1 %
- DB Delete (Table)< 1 %
DB Loader< 1 %- DB Merge< 1 %
- DB Update< 1 %
- TimeDelay Loop End< 1 %
- Bar Chart (JavaScript)< 1 %
- Histogram (JavaScript)< 1 %
- Sunburst Chart (JavaScript)< 1 %
- Variable Expressions< 1 %
- Table to HTML (legacy)< 1 %
- Table to PDF (legacy)< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
- HeatMap (JFreeChart)< 1 %
- Histogram Chart (JFreeChart)< 1 %
- Line Chart (JFreeChart)< 1 %
- Scatter Plot (JFreeChart)< 1 %
- JPython Function (Legacy)< 1 %
- JPython Script 1:1 (Legacy)< 1 %
- OSM Map View< 1 %
- Geo-Coordinate Row Filter< 1 %
Send to Power BI< 1 %TIBCO File Writer< 1 %- Java Snippet Row Filter< 1 %
Send to Tableau Server (Hyper)< 1 %- TF< 1 %
- NGram Creator< 1 %
- String Matcher< 1 %
- Tika Language Detector< 1 %
- Tika Parser URL Input< 1 %
- Dictionary Replacer (File-based)< 1 %
- Modifiable Term Filter< 1 %
- Stop Word Filter< 1 %
- Tag Filter< 1 %
RSS Feed Reader< 1 %- Stanford Tagger< 1 %
Bag of Words Creator< 1 %Document Data Extractor< 1 %- Term Vector< 1 %
Document Viewer< 1 %- Google Sheets Updater< 1 %
- Google Sheets Writer< 1 %
- Column Filter Configuration< 1 %
- Integer Slider Configuration< 1 %
- Text Output (legacy)< 1 %
- Value Filter (legacy)< 1 %
- Column Selection (legacy)< 1 %
- Container Output (Table)< 1 %
- JSON Path (Dictionary)< 1 %
- Container Output (JSON)< 1 %
- JSON Transformer< 1 %
- JSON Schema Validator< 1 %
- Ultrametric Contour Map< 1 %
- Hierarchy Extractor< 1 %
- Row to Network< 1 %
Python Script (1⇒1)< 1 %Python Script (1⇒1)< 1 %Column Selection QuickForm (legacy)< 1 %- DELETE Request< 1 %
- POST Request< 1 %
- PUT Request< 1 %
- Date&Time to String< 1 %
- Legacy Date&Time to Date&Time< 1 %
- String to Duration< 1 %
- Create Date&Time Range< 1 %
- Date&Time Shift< 1 %
- Date Field Extractor (legacy)< 1 %
- StringCell To File< 1 %
- Molecule to CDK< 1 %
- RDKit Canon SMILES< 1 %
- RDKit From IUPAC< 1 %
- Information Gain Calculator< 1 %
- Corpus Creator< 1 %
- N-Gram Extractor< 1 %
- Hash Calculator< 1 %
- Trim Image Whitespace< 1 %
- Feed Parser< 1 %
- Navigate< 1 %
- Create PDF< 1 %
- Take Screenshot< 1 %
Send Keys< 1 %Submit< 1 %
Views
- This node has no views
Workflows
(3D) Fragment library design workflowKNIME Hub- 00_Visual_Analysis_of_Sales_Data(2)KNIME Forum
- 01_Basic_XML_processing_with_XPathKNIME Hub
- 01_Basic_XML_processing_with_XPathNodePit Space
- 01_Clustering_the_Social_CommunityKNIME Hub
- Show all 486 workflows
Links
- JSON to Tableby armingrudd on 2019-04-24forum.knime.com/p/59303
- Json Path Understandingby armingrudd on 2019-06-18forum.knime.com/p/62465
- Postman & HMAC Workflowby AnotherFraudUser on 2021-12-24forum.knime.com/p/142938
- Increase date by loopingby armingrudd on 2019-11-27forum.knime.com/p/75620
- How to insert data tables from web pages?by qqilihq on 2021-11-17forum.knime.com/p/139613
- Show all 17 links
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.