topic Re: extract xml for each row in Talend Studio

extract xml for each row

Anonymous — Tue, 17 Apr 2018 08:40:13 GMT

Hello,

In my data source I have records with XML content that I want to extract and duplicate rows :

Data Source

id | content

100 | <?xml version="1.0" encoding="utf-8"?><RepeaterData><Version /><Items><Item><Years>2018</Years><data>110</data></Item><Item><Years >2019</Years><data>200</data></Item></Items></RepeaterData>

I want to get an out put like :

100 | 2018 | 110

100| 2019 | 200

which component could I use ? Any help please ?

Re: extract xml for each row

Anonymous — Tue, 17 Apr 2018 20:19:11 GMT

tExtractXMLField

Re: extract xml for each row

vboppudi — Tue, 17 Apr 2018 21:09:03 GMT

Please try below

Regards,

Re: extract xml for each row

Anonymous — Sun, 22 Apr 2018 23:22:27 GMT

Thank's for the solution !! Could you please show me the content of your tjavaRow ?

when i set context.setProperty("ID", out.id); the value of the property is lost in the tExtractXMLfield

Re: extract xml for each row

Anonymous — Mon, 23 Apr 2018 10:55:49 GMT

tjavarow code will be like this :

context.id=input_row.id; -> Assigning the context value directly.
output_row.content = input_row.content;

Re: extract xml for each row

Anonymous — Mon, 23 Apr 2018 21:47:09 GMT

I don't knoy why with context variables I'm getting empty values .

I used GlobalMap and it work's.

thank you