How to handle idRef in XML ?

Five Stars

How to handle idRef in XML ?


I got an XML file to parse, this one got reference with idRef.
I want to go through them, and insert my XML elements to database, that mean that I have to insert referenced element before creating my key.

Is there a better method ?
Here's an example, near the start of the file :
<AST00 id="1" name="test">
<LEA00 id="1">
<LEA02 idRef-LEA="22"/>

In the middle of file :
<LEA00 id="22">

Thanks a lot

Six Stars

Re: How to handle idRef in XML ?

Connect to tXmlMap and map only the fields you need

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


Definitive Guide to Data Quality

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



Introduction to Talend Open Studio for Data Integration.