This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
RE: Regrouping XML Data
- From: "Michael Kay" <michael dot h dot kay at ntlworld dot com>
- To: <xsl-list at lists dot mulberrytech dot com>
- Date: Fri, 12 Jul 2002 09:39:45 +0100
- Subject: RE: [xsl] Regrouping XML Data
- Reply-to: xsl-list at lists dot mulberrytech dot com
Here's a novel solution using XSLT 2.0 grouping:
<row>
<xsl:for-each-group select="col/data"
group-by="count(preceding-sibling::*)">
<col>
<xsl:for-each select="current-group()">
<xsl:copy-of select="."/>
</xsl:for-each>
</col>
</xsl:for-each-group>
</row>
You could of course solve it as a grouping problem in XSLT 1.0 as well.
But there are easier ways.
<xsl:variable name="row" select="."/>
<xsl:for-each select="col[1]/data">
<xsl:variable name="pos" select="position()"/>
<col>
<xsl:for-each select="$row/col/data[position()=$pos]">
<xsl:copy-of select="."/>
</
</
</
Michael Kay
Software AG
home: Michael.H.Kay@ntlworld.com
work: Michael.Kay@softwareag.com
> -----Original Message-----
> From: owner-xsl-list@lists.mulberrytech.com
> [mailto:owner-xsl-list@lists.mulberrytech.com] On Behalf Of Lotus Soda
> Sent: 12 July 2002 01:00
> To: XSL-List@lists.mulberrytech.com
> Subject: [xsl] Regrouping XML Data
>
>
> Dear Friends
>
> I have the following XML data
> <row>
> <col>
> <data>
> Surveyor
> </data>
> <data>
> Excavation
> </data>
> <data>
> Plumber
> </data>
> </col>
> <col>
> <data>
> 11/02/2000
> </data>
> <data>
> 15/02/2000
> </data>
> <data>
> 11/03/2000
> </data>
> </col>
> </row>
>
> I am having difficulty transforming this into:
>
> <row>
> <col>
> <data>
> Surveyor
> </data>
> <data>
> 11/02/2000
> </data>
> </col>
> <col>
> <data>
> Excavation
> </data>
> <data>
> 15/02/2000
> </data>
> </col>
> <col>
> <data>
> Plumber
> </data>
> <data>
> 11/03/2000
> </data>
> </col>
> </row>
>
> Each <row> has a fixed number of <col>
> Each <col> has one set of <data> (this set is variable)
> The <data> sets are equal for all <col> in each <row>
>
> Any help is appreciated
>
>
> ('J') Lotus Soda
>
>
> XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
>
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list