Icon

kn_​forum_​26995_​xml_​read_​changing_​cells

Load a collection of XML files with one changing item with the help of nested XPath definitions

Load a collection of XML files with one changing item with the help of nested XPath definitions

Define XPath with an asterix (THX Andrew_Steel for the hint)orig /dns:ICMS/dns:*/dns:orig String(SingleCell)CST /dns:ICMS/dns:*/dns:CST String(SingleCell)modBC /dns:ICMS/dns:*/dns:modBC String(SingleCell)vBC /dns:ICMS/dns:*/dns:vBC String(SingleCell)pICMS /dns:ICMS/dns:*/dns:pICMS String(SingleCell)vICMS /dns:ICMS/dns:*/dns:vICMS String(SingleCell)CSOSN /dns:ICMS/dns:*/dns:CSOSN String(SingleCell) Load a collection of XML files with one changing item with the help of nested XPath definitionshttps://forum.knime.com/t/xml-reading/26995/9?u=mlauber71 20190613_31190659717553000617550020011878611005017709.xmlNode 820190613_32190608800769000104550010000003821252821300.xmlNode 16Node 20Node 21Node 22Node 23listXMLfilesSTARTread XMLinsideICMSextract onesub-part of XML fileICMSEND XML Reader Column Filter XML Reader XPath XPath XPath Column Filter XPath List Files Table Row ToVariable Loop Start XML Reader XPath Column Filter XPath Loop End Define XPath with an asterix (THX Andrew_Steel for the hint)orig /dns:ICMS/dns:*/dns:orig String(SingleCell)CST /dns:ICMS/dns:*/dns:CST String(SingleCell)modBC /dns:ICMS/dns:*/dns:modBC String(SingleCell)vBC /dns:ICMS/dns:*/dns:vBC String(SingleCell)pICMS /dns:ICMS/dns:*/dns:pICMS String(SingleCell)vICMS /dns:ICMS/dns:*/dns:vICMS String(SingleCell)CSOSN /dns:ICMS/dns:*/dns:CSOSN String(SingleCell) Load a collection of XML files with one changing item with the help of nested XPath definitionshttps://forum.knime.com/t/xml-reading/26995/9?u=mlauber71 20190613_31190659717553000617550020011878611005017709.xmlNode 820190613_32190608800769000104550010000003821252821300.xmlNode 16Node 20Node 21Node 22Node 23listXMLfilesSTARTread XMLinsideICMSextract onesub-part of XML fileICMSENDXML Reader Column Filter XML Reader XPath XPath XPath Column Filter XPath List Files Table Row ToVariable Loop Start XML Reader XPath Column Filter XPath Loop End

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: m_lauber
Created at: 2020-09-11
On NodePit since: 2020-09-19
Last update: 2024-05-02
Created with KNIME version: v4.2.1

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

Try NodePit Runner!