In my data source I have records with XML content that I want to extract and duplicate rows :
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 ?
Solved! Go to Solution.
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
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables