I want to parse XML and get data from it in table format. I am using xpath node for this purpose.
XML has fixed set of nodes however the attribute of parent node may vary. E.g. some nodes may not have few attributes. See screenshot below. First variable node has two attributes less than second one.
In this case what I am expecting is for xpath to return missing cell for first one and value for second node in second row. Please see the way I have configured xpath. As attribute name has colon in it, I had to use name function.
The problem is xpath instead of returning blank cell in missing attribute column in first row it traverses further nodes till it finds attribute and gets that value. Hence output table has mixed values in a row.
Please suggest how can I fix it.
One another note, please suggest if there is any way to concatenate two xpath values in same column in knime xpath node.