Re: Xquery help to add element to loop

The correct list is: http://x-query.com/mailman/listinfo/talk


On 26 August 2011 14:21, sudheshna iyer <sudheshnaiyer@xxxxxxxxx> wrote:
> I want to prepare an element of complex type and add it to the list of
elements. How can I achieve this in xquery? I am using oepe..
>
> I am not sure whether this is the right forum for xquery. If not, do any
body know the right forum for xquery?
> =============
> Input.xml
> <customer>
>  <HeaderLevel>
>   <Id>3</Id>
>   <HAddressLine1>haa</HAddressLine1>
>   <HAddressLine2>hbb</HAddressLine2>
>  </HeaderLevel>
>  <Addresses>
>   <Address>
>    <Id>1</Id>
>    <AddressLine1>aa</AddressLine1>
>    <AddressLine2>bb</AddressLine2>
>   </Address>
>   <Address>
>    <Id>2</Id>
>    <AddressLine1>aa</AddressLine1>
>    <AddressLine2>bb</AddressLine2>
>   </Address>
>  </Addresses>
> </customer>
> =============
> Output  should be:
> <?xml version="1.0" encoding="UTF-8"?>
> <customer_transitioned>
>  <Addresses_transitioned>
>   <Address_transitioned>
>    <Id_t>1</Id_t>
>    <AddressLine1_t>aa</AddressLine1_t>
>    <AddressLine2_t>bb</AddressLine2_t>
>   </Address_transitioned>
>   <Address_transitioned>
>    <Id>2</Id>
>    <AddressLine1_t>aa</AddressLine1_t>
>    <AddressLine2_t>bb</AddressLine2_t>
>   </Address_transitioned>
>   <Address_transitioned>
>    <Id>3</Id>
>    <AddressLine1_t>haa</AddressLine1_t>
>    <AddressLine2_t>hbb</AddressLine2_t>
>   </Address_transitioned>
>  </Addresses_transitioned>
> </customer_transitioned>
>
> =============
>
>



--
Andrew Welch
http://andrewjwelch.com