Description
Xpath unable to parse node if the elements are formatted at the same node level
ex:
<abc>
<xyz>
<field1><subProp1>Some Val1</subProp1></field1>
<field2><subProp2>Some Val2</subProp2></field2>
<field3><subProp3>Some Val3</subProp3></field3>
<field4><subProp4>Some Val4</subProp4></field4>
</xyz>
</abc>
Steps to Reproduce
- Create an XML data source with XML from the Description.
- Set the XPath to /abc/xyz.
- Load All Records
- No records are inserted. Expected behavior is that 1 record will be inserted into the with 4 values, field1, field2, field3, field4. Each should have an XML fragment similar to "<?xml version="1.0" encoding="UTF-8"?><field1><subProp1>Some Val1</subProp1></field1>".
Workaround
Two potential workarounds include:
- Alter source XML to include carriage returns for all children nodes
- Specify 'expand node children' in the data source. This will insert the record and the child elements will be converted into additional columns. So the example above, the record will still include empty values for field1, field2, field3, field4, but will include values for additional columns field1/subProp1, field2/subProp2, field3/subProp3, field4/subProp4
Related Problem: PRB1158748