Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Labels (3)
1 Reply
Anonymous
Not applicable
Author

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