Five Stars

extract xml for each row

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 ?

1 ACCEPTED SOLUTION

Accepted Solutions
Nine Stars

Re: extract xml for each row

Please try below

 

XMLExtract.PNGXMLExtract1.PNG

 

Regards,

Veeru Boppudi
5 REPLIES
Moderator

Re: extract xml for each row

tExtractXMLField

Nine Stars

Re: extract xml for each row

Please try below

 

XMLExtract.PNGXMLExtract1.PNG

 

Regards,

Veeru Boppudi
Five Stars

Re: extract xml for each row

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

Four Stars

Re: extract xml for each row

tjavarow code will be like this :

 

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

 

Five Stars

Re: extract xml for each row

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

I used GlobalMap and it work's.

thank you