One Star

Problem with an Xpath expression with Sax parser

Hello
I'm using a tFileInputXml to parse a XML File. To select fields, i'm using Xpath expression :
Donnees/Liste/Ligne/@nouval
It's OK with Dom4j parser, data are OK. With SAX there is no Error but my Xpath expression give no data (my field is blank)
The structure of my xml file:
<Evenement>
<Identification>
<code_evt_fonctionnel>51S</code_evt_fonctionnel>
<timestamp>2009-09-28-20.39.36.233658</timestamp>
<appli>BASE_NATIONALE</appli>
</Identification>
<EnTete>
<DSTRTX>20090928</DSTRTX>
<HSTRTX>20393623</HSTRTX>
<CSPHCA>P0151S</CSPHCA>
<CXASS>017</CXASS>
<CXIDT>1026041129</CXIDT>
<CODEACTION>M</CODEACTION>
</EnTete>
<Donnees>
<Liste>
<Ligne code="TSP51S" nouval="2009-09-28-20.39.36.233658" />
<Ligne code="CXALA" nouval="1026041129" />
<Ligne code="CDOM" nouval="RE" />
</Liste>
</Donnees>
</Evenement>
Thanks for your help
1 REPLY
Community Manager

Re: Problem with an Xpath expression with Sax parser

Hello
Donnees/Liste/Ligne/@nouval

Talend doesn't support such expression, set the xpath expression as:
/Evenement/Donnees/Liste/Ligne
and get all the records, then filter records on tfilterRow or tMap component.
Best regards

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