tXMLFileInput - XPath branch (*)

One Star

tXMLFileInput - XPath branch (*)

I can not get an entire node set from the tXMLFileInput component using DOM4J. If I set the parser to Xerces, I get the node set but only the values and all of them are merged into one string without spaces.
In the example below I would expect to get the entire "<cont>" node with all it's siblings, but I get "" (nothing) using DOM4J and "GHASA.sdweFESDF.esgwGHASA.skweFESDF.esty" using Xerces.
Ideas anyone?
The xPath definition:
"arglist/arg/attrlist/attr/*"
XML:
<resp >
<arglist>
<arg name="Show Values">
<attrlist>
<attr name="Primary">
<cont>
<el>
<aes>
<name>GHAS</name>
<val>A.sdwe</val>
<name>FESD</name>
<val>F.esgw</val>
</aes>
</el>
<el>
<aes>
<name>GHAS</name>
<val>A.skwe</val>
<name>FESD</name>
<val>F.esty</val>
</aes>
</el>
</cont>
</attr>
</attrlist>
</arg>
</arglist>
</resp>
Community Manager

Re: tXMLFileInput - XPath branch (*)

Hello
"arglist/arg/attrlist/attr/*"

Talend doesn't support this kind of xpath expression.
In your case, you need to use a tFileInputxml to set 'name' as loop node(see pic1) and get all values of 'name' node, and use another tFileInputxml to set 'var' as loop node(see pic2) and get all values of 'var' node, then meger/concatanate the two flow to one and filter rows if needed.
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business