extract xml for each row

[Anonymous]

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 ?

[Anonymous]

tExtractXMLField

[vboppudi · Accepted solution]

Please try below

Regards,

[Anonymous]

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

[Anonymous]

tjavarow code will be like this :

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

[Anonymous]

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

I used GlobalMap and it work's.

thank you