topic Re: How to parse this XML file please in Talend Studio

How to parse this XML file please

Anonymous — Sat, 16 Nov 2024 12:23:23 GMT

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

Re: How to parse this XML file please

Anonymous — Fri, 10 Feb 2012 09:23:23 GMT

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

Re: How to parse this XML file please

Anonymous — Fri, 10 Feb 2012 09:31:17 GMT

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

Re: How to parse this XML file please

Anonymous — Fri, 10 Feb 2012 09:36:20 GMT

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

Re: How to parse this XML file please

Anonymous — Fri, 31 Jan 2014 06:47:54 GMT

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