Hello, I have some problems to write data in an specific XML file format I want to build a file from this row format Column Type channel_id (int) program_id (int) program (DomElement) My output file should have this structure <channels> (my root element) <channel channel_id="1"> <program program_id="1"> <programdomcontent/> </program> <program program_id="2"/> <programdomcontent/> </program> </channel> <channel channel_id="2"> <program program_id="3"/> <programdomcontent/> </program> <program program_id="4"/> <programdomcontent/> </program> </channel> </channels>
Currently I'm using a tJavaFlex with org.dom4j.Element to perform the xml build. I tried to use the tAdvancedFileOutputXML instead, with no success. How can I transform my rows in the desired XML file format? Can anyone help me or give me a lead ?
Hi Pedro, Thanks for your answer ! I tried your solution and added a second loop on program. The XML Output structure is here. Now I've problem with the DomElement. I want my program column to be the program XML element. With the current solution, my program column content is added as text ("<" and ">" are encoded as "<" and ">") and can not be parsed properly... Regards, Max