I’m trying to parse this XML into a table. I typically use Xpath but this is strange type of XML that I haven’t seen before. It’s saying, “Selected XML element is not a tag nor an attribute” on everything I click on. I basically need I, Q, P, C as the table headers. I appreciate the assistance.
1 Like
Hi @JDofSC ,
It looks like the content you’re working with isn’t being presented as structured XML. All the < and > characters have been converted into HTML entities (<, >, etc.), which means the XML parser only sees plain text rather than actual tags. That’s why KNIME reports that the selected elements are “not a tag nor an attribute.”
This might happen when a web service or other call returns XML wrapped inside a string field, or when something upstream “escapes” the content for transport.
I would suggest first converting those escaped entities back to real XML before running it through XPath. For example, you could try replacing < with < and >' with >’ using String Manipulation, Regex Replace, or a String Replacer node, for example.
5 Likes
Hi @JDofSC ,
as @takbb wrote your XML-structure semms not to be normal XML structure. If I had to work with such data ich would try to handle it like a text file. With the Cell Splitter Node you can splitt your data for exaple with “;”. Then you have to clean your tabel an as last step transform or pivot your table. You should now have a table with I, Q, P, C Columns and your values.
1 Like