extract xml for each row

Six 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 ?


Accepted Solutions
Nine Stars

Re: extract xml for each row

Please try below

 

XMLExtract.PNGXMLExtract1.PNG

 

Regards,

Veeru Boppudi

All 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
Six 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;

 

Six 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 

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch