Hello
You can use the 'Append the source xml file' feature on tAdvancedFileoutputXML, here I extract records fron xml 2 and insert them into xml 1. Please see my screenshots.
result:

<?xml version="1.0" encoding="ISO-8859-15"?>

<CustomerInvoices>
  <CustomerInvoice>
    <InvoiceHeader>
      <RefNumber>6004</RefNumber> 
      <Date>25-08-2009</Date> 
      <CreationDateTime>25-08-2009</CreationDateTime> 
      <Currency>EUR</Currency> 
      <Booking>
        <BookingID>2004</BookingID> 
        <TotalAmount>100</TotalAmount> 
        <BookingContextAxisList>
          <Context>
            <ContextName>CUSTOMER_MARKET</ContextName>
            <Value>CASSURA</Value>
          </Context>
          <Context>
            <ContextName>CUSTOMER_MARKET</ContextName>
            <Value>FR</Value>
          </Context>
        </BookingContextAxisList>
      </Booking>
    </InvoiceHeader> 
    <invoiceItems>
      <invoiceItem>
        <SeqNumber>6007</SeqNumber> 
        <BookingFinancialTransaction>
          <BookingFinancTransRef>107</BookingFinancTransRef> 
          <NbPassenger>0</NbPassenger>
        </BookingFinancialTransaction>
      </invoiceItem>
    </invoiceItems>
  </CustomerInvoice>
</CustomerInvoices>


Best regards

         shong

Hello Shong

Sorry , maybe I didnt mentioned properly.

the xml 2 is like this

<CustomerInvoice>
    <Booking>
    <BookingID>2004</BookingID>
    <BookingContextAxisList>
      <Context>
        <ContextName>CUSTOMER_MARKET</ContextName>
        <Value>CASSURA</Value>
      </Context>
      <Context>
        <ContextName>CUSTOMER_MARKET</ContextName>
        <Value>FR</Value>
      </Context>
    </BookingContextAxisList>
  </Booking>
  <Booking>
  <Booking>
    <BookingID>2008</BookingID>
    <BookingContextAxisList>
      <Context>
        <ContextName>CUSTOMER_MARKET</ContextName>
        <Value>VALUE FOR BOOK 2008</Value>
      </Context>
      <Context>
        <ContextName>CUSTOMER_MARKET</ContextName>
        <Value>EN</Value>
      </Context>
    </BookingContextAxisList>
  </Booking>
</CustomerInvoice>


I tried your recomendation, but the result is that the xml 2 was inserted completly in the first appear . What I need is to insert the BookingContextAxisList of each booking to his corresponding Booking in XML 1

shong wrote:

Hello
Aslo extract the booking id from xlm2, and then set booking element as group element.

Best regards
   
         shong

mbernaza: Did this solution work? The ability to construct a complex, hierarchical XML document from a DB flow is critical for us. Would another approach be more robust, such as using tJavaRow, and leveraging either the DOM or, easier still, a Java XML data binding tool (Castor, JAXB, Liquid Tech's, etc.).