XML Processiong

[Sweden7]

Hey All,

I have an xml file generate from Accounting ERP of 7MB.
used the xml reader node which got executed and the entire xml is appearing in a cell.

I used the xpath node to parse the xml with the intention of converting data into a tabular format…

when I click on settings button of the xpath node / execute the xpath node…
KNIME Hangs …it stays unresponsive for long …
tried this by reinstalling KNIME, increasing the size allocation … nothing works…

need support…

[mlauber71]

@Sweden7 welcome to the KNIME forum. Can you give use more details about what is going on. Or can you provide some sample data?

Problem with XML Reader

@Martin2024 maybe you can give this example a try. The XML is initially 500 MB and does work on my M1 machine with 15 GB assigned to KNIME 5.4 and Columnar Backend activated for the workflow. The handling of Path for XML or JSON requires some trials and experimenting unless you are very familiar with the structures (in the case of JSON also some ungroup might be necessary cf. also the additional links). [image] [image]

In theory you could convert XML to JSON and then try to automatically convert that to a table but you will have to see if this will be suitable

[McReady]

Yes, XML and JSON parsing is a PITA in KNIME, also the XPath / JSON Path nodes are acting very “beta-like” sometimes. Best practice advice I can give: Use an external tool like Notepad++ with JSON or XML plugin, extract the correct path there and paste it to the KNIME node. Usually, this helps, especilly while handling large datasets like in your case.