Icon

02_​XML_​processing_​(Bush_​books)_​XPath_​mo_​working

XML Processing with XPath (Bush books)

This workflow reads and processes an XML file describing books that were written by or about George W. Bush.

The workflow extracts all information such as ISBN, author, title, etc. and groups the books by category. The output file is an xml file but in a different format (grouped by year).

Note: the XML does not contain namespace information, which makes reading the XML easier as when there are name spaces in the XML.

This workflow reads from an XML file describing books that were written by or about George W. Bush. read book inventoryall books yearsin one filecolor by categoryremove XML column#books per authorcount works by authorby yearfor each yearcurrent yearall books in yearcount per categorytitleextract title, author, year, category, ISBNall books yearsin one fileisbnNode 74authorby year XML Reader XML Row Combineand Write Color Manager Column Filter(deprecated) Sorter Value Counter GroupBy Table Row ToVariable Loop Start Row Filter XML Row Combiner Loop End InteractiveHistogram (local) Column To XML Create Temp Dir Extract bookinformation XML Row Combineand Write Column To XML XML Column Combiner Column To XML GroupBy This workflow reads from an XML file describing books that were written by or about George W. Bush. read book inventoryall books yearsin one filecolor by categoryremove XML column#books per authorcount works by authorby yearfor each yearcurrent yearall books in yearcount per categorytitleextract title, author, year, category, ISBNall books yearsin one fileisbnNode 74authorby yearXML Reader XML Row Combineand Write Color Manager Column Filter(deprecated) Sorter Value Counter GroupBy Table Row ToVariable Loop Start Row Filter XML Row Combiner Loop End InteractiveHistogram (local) Column To XML Create Temp Dir Extract bookinformation XML Row Combineand Write Column To XML XML Column Combiner Column To XML GroupBy

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
On NodePit since: 2020-10-31
Last update: 2024-04-25
Created with KNIME version: v4.2.2
Tags: xmlxpathstructured data

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!