Missing Data While Converting XML to Excel Using XPath in KNIME

Hi,

I’m trying to convert an XML file to Excel in KNIME. I’m using:

*

XML Reader to load the XML file

*

XPath node to extract multiple fields

*

Excel Writer to export the result

The problem is:

*

If I extract only one field (e.g.,

id

), all data shows correctly.

*

But when I add more XPath fields (like

name

,

address

, etc.), some data starts showing as missing, even for the

id

column that was working before.

*

All XPath paths are correct — I double-checked them.

It seems like the data structure is getting misaligned when extracting multiple fields from nested XML.

Has anyone faced this? What’s the best way to convert XML to Excel without missing or misaligned data?