xsl-list
[Top] [All Lists]

[xsl] Help with Transformation

2007-10-29 12:03:46

Iam fairly new to xsl and iam stuck, i would greatly appreciate if someone 
could help me out here, below are the input and output xml documents

Input xml
<Customer>
   <CustomerAccount>
      <ResponseHeader>
         <CorrelationId>1234</CorrelationId>
   </ResponseHeader>
      <ResponseStatus>
         <Status>Success</Status>
      </ResponseStatus>
      <CustomerSet>
         <CustomerName>Pizza Hut</CustomerName>
         <Product>Product 1</Product>
         <PurchaseMonth>October 2007</PurchaseMonth>
        <AddressSet>
          <Address>1 main st</Address>
          <Address>2 river st</Address>
          <Address>3rd st</Address>
        </AddressSet>
         <ZipSet>
            <Zip>199360</Zip>
            <Zip>94596</Zip>
            <Zip>07974</Zip>
         </ZipSet>
   </CustomerSet>
      <CustomerSet>
         <CustomerName>Dominos</CustomerName>
         <Product>Product 2</Product>
         <PurchaseMonth>October 2007</PurchaseMonth>
        <AddressSet>
          <Address>21 Elm Road</Address>
          <Address>55 Green St</Address>
         </AddressSet>
         <ZipSet>
            <Zip>2583</Zip>
            <Zip>48818</Zip>
         </ZipSet>
   </CustomerSet>
   </CustomerAccount>
<Customer>

Below should be my output after transformation
<ListOfCustomers>
   <MyCustomer>
      <Id>1234</Id>
      <AccountName>Pizza Hut</AccountName>
      <BillMonth>October 2007</BillMonth>
      <Product>Product 1</Product>
      <Address>1 main st</Address>
      <Zip>199360</Zip>
   </MyCustomer>
   <MyCustomer>
      <Id>1234</Id>
      <AccountName>Pizza Hut</AccountName>
      <BillMonth>October 2007</BillMonth>
      <Product>Product 1</Product>
      <Address>2 river st</Address>
      <Zip>94596</Zip>
   </MyCustomer>
   <MyCustomer>
      <Id>1234</Id>
      <AccountName>Pizza Hut</AccountName>
      <BillMonth>October 2007</BillMonth>
      <Product>Product 1</Product>
      <Address>3rd st</Address>
      <Zip>07974</Zip>
   </MyCustomer>
   <MyCustomer>
      <Id>1234</Id>
      <AccountName>Dominos</AccountName>
      <BillMonth>October 2007</BillMonth>
      <Product>Product 2</Product>
      <Address>21 Elm Road</Address>
      <Zip>2583</Zip>
   </MyCustomer>
   <MyCustomer>
      <Id>1234</Id>
      <AccountName>Dominos</AccountName>
      <BillMonth>October 2007</BillMonth>
      <Product>Product 2</Product>
      <Address>55 Green St</Address>  
      <Zip>48818</Zip>
   </MyCustomer>
</ListOfCustomers>

Thank you for all your help in advance. 





--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--

<Prev in Thread] Current Thread [Next in Thread>