Grouping problem...

Here should go questions about transforming XML with XSLT and FOP.
undrmoons
Posts: 11
Joined: Sat Jan 14, 2006 7:17 pm
Contact:

Grouping problem...

Post by undrmoons » Sat Jan 14, 2006 7:19 pm

The data I'm working with is coming from an unstructured table source - there is nothing to indicate that a row has ended, other than the sequence of elements.

When the <Price> element is followed by any other element other than itself, (like SKU in this example) I'd like to make thta my indicator of the end of a group.

The input XML is similar to this:
---------------------------------
<onepage>
<prodgroup>
<SKU>No. 447139K5</SKU>
<Price>Price 15.99</Price>
</prodgroup>
<prodgroup>
<SKU>456291K5</SKU>
<SKU>456225K5</SKU>
<SKU>456209K5</SKU>
<Price>159.99</Price>
<Price>169.99</Price>
<SKU>484697K5</SKU>
<SKU>456299K5</SKU>
<SKU>574599K5</SKU>
<Price>169.99</Price>
<Price>169.99</Price>
<SKU>484557K5</SKU>
<SKU>484545K5</SKU>
<SKU>484527K5</SKU>
<Price>169.99</Price>
<Price>289.99</Price>
</prodgroup>
<prodgroup>
<SKU>456237K5</SKU>
<Price>169.99</Price>
<Price>169.99</Price>
<Price>169.99</Price>
<Price>189.99</Price>
<SKU>484552K5</SKU>
<Price>169.99</Price>
<Price>169.99</Price>
<Price>169.99</Price>
<Price>309.99</Price>
</prodgroup>
</onepage>
---------------------------------

The ideal result of XML would be:

---------------------------------
<onepage>
<table>
<row>
<SKU>447139K5</SKU>
<Price>15.99</Price>
</row>
</table>
<table>
<row>
<SKU>456291K5</SKU>
<SKU>456225K5</SKU>
<SKU>456209K5</SKU>
<Price>159.99</Price>
<Price>169.99</Price>
</row>
<row>
<SKU>484697K5</SKU>
<SKU>456299K5</SKU>
<SKU>574599K5</SKU>
<Price>169.99</Price>
<Price>169.99</Price>
</row>
<row>
<SKU>484557K5</SKU>
<SKU>484545K5</SKU>
<SKU>484527K5</SKU>
<Price>169.99</Price>
<Price>289.99</Price>
</row>
</table>
<table>
<row>
<SKU>456237K5</SKU>
<Price>169.99</Price>
<Price>169.99</Price>
<Price>169.99</Price>
<Price>189.99</Price>
</row>
<row>
<SKU>484552K5</SKU>
<Price>169.99</Price>
<Price>169.99</Price>
<Price>169.99</Price>
<Price>309.99</Price>
</row>
</table>
</onepage>

---------------------------------

The XSLT that I've currently written doesn't work properly because I'm using group-ending-with="Price".
Since the Price element can sometimes follow itself,
this creates an unwanted break in my result XML.

Any help would be GREATLY appreciated!

Thanks in advance!
-lmm

george
Site Admin
Posts: 2101
Joined: Thu Jan 09, 2003 2:58 pm

Post by george » Sun Jan 15, 2006 1:13 pm

Hi Imm,

You can group the items based on the starting element, that is a SKU that is not preceded by another SKU element, so we take the first preceding sibling element and test not to be a SKU. Full XSL code below:

Code: Select all


<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> 
<xsl:template match="onepage">
<onepage>
<xsl:apply-templates/>
</onepage>
</xsl:template>
<xsl:template match="prodgroup">
<table>
<xsl:for-each-group select="*"
group-starting-with="SKU[not(preceding-sibling::*[1][self::SKU])]">
<row>
<xsl:for-each select="current-group()">
<xsl:copy-of select="."/>
</xsl:for-each>
</row>
</xsl:for-each-group>
</table>
</xsl:template>
</xsl:stylesheet>
Best Regards,
George

Post Reply