One Star

How to parse this XML file please

Hi,
here is my XML file:
<ressource>
<identifier>C4103</identifier>
<topic>culture</topic>
<topic>philosophy</topic>
<loc longitude="-0.32" latitude="43.7"/>
<loc longitude="-0.34" latitude="44.1"/>
</ressource>
I would like to obtain something like:
identifier C4103
topic culture;philosophy
loc -0.32/43.7;-0.34/44.1
I am not able to do this with a tfileInputXML, neither with tfileInputMSXML.
Anyone has an idea please ?
Should I use an XSLT transformation instead ?
Thanks
Regards
4 REPLIES
One Star

Re: How to parse this XML file please

Hi
Create metadata-->FileXML as the following image.
Regards,
Pedro
One Star

Re: How to parse this XML file please

I doesn't work. Here is the result:
C4103|culture|43.7|-0.266667
C4103|culture|44.1|-0.24
'Philosophy' has not been extracted ...
One Star

Re: How to parse this XML file please

Hi
Sorry. I didn't notice that.
Uh...That means you need two loop paths, which is impossible with tfileInputXML, tfileInputMSXML.
Anybody knows this?
Regards,
Pedro
One Star

Re: How to parse this XML file please

Hi,
Can you anyone tell me how to convert a XML file into table format using Talend Open Studio V4.0.3?
Thank you