XSLT Transformation

[Jens Hofmeier]

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

[msbalaji]

Hi,

try this code

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/
Transform">
<xsl:output method="xml" indent="yes"/>
<xsl:template match="Location">
<xsl:for-each select="//ArticleMisc">
<Location>
<xsl:copy-of select="../../ArticleDescription"/>
<ArticleMiscs>
<xsl:copy-of select="."/>
</ArticleMiscs>
</Location>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>

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

On Jul 15, 11:56*am, Jens Hofmeier <[e-mail]:

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

[Jens Hofmeier]

Great! Thanks a lot!

msbalaji <[e-mail]:

Hi,

try this code

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/
Transform">
<xsl:output method="xml" indent="yes"/>
<xsl:template match="Location">
<xsl:for-each select="//ArticleMisc">
<Location>
<xsl:copy-of select="../../ArticleDescription"/>
<ArticleMiscs>
<xsl:copy-of select="."/>
</ArticleMiscs>
</Location>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>

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

On Jul 15, 11:56*am, Jens Hofmeier <[e-mail]:

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,

Je