XSLT Transformation

XSLT Transformation

Hi,

i am quite new to xml and need to transform an existing xml file:
<Location>
          <ArticleDescription>
            <Description>Shirt Hawaii</Description>
           </ArticleDescription>
        <ArticleMiscs>
          <ArticleMisc>
            <Country>DEU</Country>
            <Size>32</Size>
          </ArticleMisc>
          <art:ArticleMisc>
            <Country>USA</art:Country>
            <Size>XS</art:Size>
          </ArticleMisc>
          <ArticleMisc>
            <Country>GBR</art:Country>
            <Size>6</art:Size>
          </ArticleMisc>
         </ArticleMiscs>
</Location>

this should be transformed to:

<Location>
          <ArticleDescription>
            <Description>Shirt Hawaii</Description>
           </ArticleDescription>
        <ArticleMiscs>
          <ArticleMisc>
            <Country>DEU</Country>
            <Size>32</Size>
          </ArticleMisc>
       </ArticleMiscs>
</Location>

<Location>
           <ArticleDescription>
            <Description>Shirt Hawaii</Description>
           </ArticleDescription>
        <ArticleMiscs>
           <ArticleMisc>
            <Country>USA</art:Country>
            <Size>XS</art:Size>
          </ArticleMisc>
       </ArticleMiscs>
</Location>

<Location>
          <ArticleDescription>
            <Description>Shirt Hawaii</Description>
           </ArticleDescription>
        <ArticleMiscs>
          <ArticleMisc>
            <Country>GBR</art:Country>
            <Size>6</art:Size>
          </ArticleMisc>
       </ArticleMiscs>
</Location>

So the original file contains 3 "ArticleMisc" Sections per <Location>,
the tranformed one only one Misc per Location. Can anybody give me a
hint how this van be done via XSLT?

Thanks,

Jens

date: Tue, 15 Jul 2008 00:46:56 -0700 (PDT) author: Jens Hofmeier

Re: XSLT Transformation

Hi,

 Don't repeat the same question to all the xsl group. :-)

 Asnwer

 http://groups.google.co.in/group/comp.text.xml/browse_thread/thread/707bbe165c9adfbf?hl=en#

Regards,
Balaji. M
sql-ebooks.blogspot.com

On Jul 15, 12:46 pm, Jens Hofmeier  wrote:
> Hi,
>
> i am quite new to xml and need to transform an existing xml file:
> <Location>
>           <ArticleDescription>
>             <Description>Shirt Hawaii</Description>
>            </ArticleDescription>
>         <ArticleMiscs>
>           <ArticleMisc>
>             <Country>DEU</Country>
>             <Size>32</Size>
>           </ArticleMisc>
>           <art:ArticleMisc>
>             <Country>USA</art:Country>
>             <Size>XS</art:Size>
>           </ArticleMisc>
>           <ArticleMisc>
>             <Country>GBR</art:Country>
>             <Size>6</art:Size>
>           </ArticleMisc>
>          </ArticleMiscs>
> </Location>
>
> this should be transformed to:
>
> <Location>
>           <ArticleDescription>
>             <Description>Shirt Hawaii</Description>
>            </ArticleDescription>
>         <ArticleMiscs>
>           <ArticleMisc>
>             <Country>DEU</Country>
>             <Size>32</Size>
>           </ArticleMisc>
>        </ArticleMiscs>
> </Location>
>
> <Location>
>            <ArticleDescription>
>             <Description>Shirt Hawaii</Description>
>            </ArticleDescription>
>         <ArticleMiscs>
>            <ArticleMisc>
>             <Country>USA</art:Country>
>             <Size>XS</art:Size>
>           </ArticleMisc>
>        </ArticleMiscs>
> </Location>
>
> <Location>
>           <ArticleDescription>
>             <Description>Shirt Hawaii</Description>
>            </ArticleDescription>
>         <ArticleMiscs>
>           <ArticleMisc>
>             <Country>GBR</art:Country>
>             <Size>6</art:Size>
>           </ArticleMisc>
>        </ArticleMiscs>
> </Location>
>
> So the original file contains 3 "ArticleMisc" Sections per <Location>,
> the tranformed one only one Misc per Location. Can anybody give me a
> hint how this van be done via XSLT?
>
> Thanks,
>
> Jens

date: Tue, 15 Jul 2008 02:32:14 -0700 (PDT) author: msbalaji