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>
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
