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