I am parsing a XML which has complex and inconsistent hierarchy. So in my Knime workflow I am using multiple Xpath nodes, concatenate nodes and so on.
Workflow was running fine until I added additional two additional xpath nodes to further parse two xml columns from previous output one followed by other. Second node is failing with following error:
ERROR XPath 0:64 Execute failed: Encountered duplicate row ID “Row0_1_4_1_1”
I checked in output of previous xpath node and there is only one row with Row0_1_4_1_1 id. It has however ? in the column which I have used as xml source column in a xpath node which is failing. Could that be the reason? How can I avoid this error? What is the purpose of row id? Why would duplicates matter for xpath?
Sorry for not being specific. I meant to ask what is the purpose of rowID which is generated by concatenate node. In my case it was not required and causing error so I was curious why would knime create it in the first place.
The nodes are working fine. I think the problem is that you had a row ID “row0_1_4_1” and a row ID: “row0_1_4_1_1” and operating on the former row creates a row ID with the same ID as the latter one. So the node throws an error.
I’m not 100% sure about this but I’m pretty sure the Concatenate node is working fine.