topic Re: Dynamic xml schema in Talend Studio

Dynamic xml schema

hiba1 — Mon, 11 Jan 2021 13:52:56 GMT

Hi all,

it's possible to create a dynamic xml schema with talend !

for example :

this is my xml schema :

<Head><

Username>test</Username>

</Head>

<Body>

<HotelId>hotelId</HotelId>

</HotelIds>

</Body>

</Request>

**********

the hotelId will be inserted from sql table ....i'm able to inesrt up to 500 hotelId to xml file.

My goal is to make the node <hotelId> become added dynamically as the number of hotelId extracted from the sql table .

like this :

<Head><

Username>test</Username>

</Head>

<Body>

<HotelId>hotelId</HotelId>

......... 500 times

<HotelId>hotelId</HotelId>

</HotelIds>

</Body>

</Request>

any help please!

Thanks

Anonymous — Tue, 12 Jan 2021 12:40:36 GMT

If I understand your question well, you just need to set the HotelId as loop element in the XML Tree structure of tAdvancedFileOutputXML.

hiba1 — Tue, 12 Jan 2021 14:23:50 GMT

Hi @Shicong Hong ,

thanks for reply . you help me.

i have up to 300000 hotelId, my question is how can i have each 500 hotelId in one file.

this is my job :

Thanks.