Solved: Dynamic xml schema - Qlik Community

hiba1 · ‎2021-01-11

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 · ‎2021-01-12

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

Anonymous · ‎2021-01-12

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

hiba1 · ‎2021-01-12

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.

Dynamic xml schema