Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
it's possible to create a dynamic xml schema with talend !
for example :
this is my xml schema :
<Request>
<Head><
Username>test</Username>
<Password>test</Password>
<RequestType>test</RequestType>
</Head>
<Body>
<HotelIds>
<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 :
<Request>
<Head><
Username>test</Username>
<Password>test</Password>
<RequestType>test</RequestType>
</Head>
<Body>
<HotelIds>
<HotelId>hotelId</HotelId>
......... 500 times
<HotelId>hotelId</HotelId>
</HotelIds>
</Body>
</Request>
any help please!
Thanks
If I understand your question well, you just need to set the HotelId as loop element in the XML Tree structure of tAdvancedFileOutputXML.
If I understand your question well, you just need to set the HotelId as loop element in the XML Tree structure of tAdvancedFileOutputXML.
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.