Icon

Read XML, dynamically extract data and combine everything

https://forum.knime.com/t/xml-file-reading/19201 Each Objektbezeichnungis going to be duplicatedfor the amount ofRZustand present Separating here forconvenience / ability tomanage, inspect andwork with each element Mergin all results into onehumongous table fordaark data magic Read full fileSeparateparent elementsinto rowsExtract infomrationof children fromInspizierteAbwassertechnischeAnlageExtract all RZustand childreninto corresponding columnsExtract informationof childrenfrom RohrleitungExtract informationof childrenfrom RGrunddatenExtract allRZustandfrom InspektionsdatenExtract allRZustandfrom InspektionsdatenExtract infomrationof children fromInspizierteAbwassertechnischeAnlageSeparateRGrunddateninto rowsExtract informationof childrenfrom InspektionsdatenNOTEAppend is more elegantand performant than join!XML Reader XPath XPath XPath XPath XPath XPath XPath XPath XPath XPath MAGIC – Convert XML to dynamically extractattributes into corresponding columns Column Appender Column Appender Joiner https://forum.knime.com/t/xml-file-reading/19201 Each Objektbezeichnungis going to be duplicatedfor the amount ofRZustand present Separating here forconvenience / ability tomanage, inspect andwork with each element Mergin all results into onehumongous table fordaark data magic Read full fileSeparateparent elementsinto rowsExtract infomrationof children fromInspizierteAbwassertechnischeAnlageExtract all RZustand childreninto corresponding columnsExtract informationof childrenfrom RohrleitungExtract informationof childrenfrom RGrunddatenExtract allRZustandfrom InspektionsdatenExtract allRZustandfrom InspektionsdatenExtract infomrationof children fromInspizierteAbwassertechnischeAnlageSeparateRGrunddateninto rowsExtract informationof childrenfrom InspektionsdatenNOTEAppend is more elegantand performant than join!XML Reader XPath XPath XPath XPath XPath XPath XPath XPath XPath XPath MAGIC – Convert XML to dynamically extractattributes into corresponding columns Column Appender Column Appender Joiner

Nodes

Extensions

Links

Download

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

Download Workflow
Created by: mw
Created at: 2019-11-02
On NodePit since: 2021-07-01
Last update: 2024-04-16
Created with KNIME version: v4.0.2

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

Try NodePit Runner!