XML generation from oracle database

PAGESC — Sat, 16 Nov 2024 02:01:14 GMT

Hi, Here is my job :

it creates an output XML file using data taken from the oracle database. Here is the content of the XML Map :

the element on which I loop (indicator) has a xsi:type and depending on this type there are more or less fields

So my question is how to take this type into account in talend ?

This is what I get with my job :

and this is what I should get :

We observe that for xsi:type= 'L3 ' only 3 fields appear however in my job it displays all possible fields.

How can i update the job to take into account the right number of fields depending to the type (as defined in the XSD file) ?

Thank you for your help.

topic XML generation from oracle database in Talend Studio