group data in table based on a value

praveenanekalmat · January 6th, 2009, 07:37 AM

Hi...

I need to split table based on a tag value. Please refer the below code which is the input xml for me

Code:

<exception>
    <funcid>Upld002</funcid>
    <header>Test1</header>
    <rec>Rec001</rec>


</exception>
<exception>
    <funcid>Upld003</funcid>
    <header>Test1</header>
    <rec>Rec001</rec>
</exception>
<exception>
    <funcid>Upld003</funcid>
    <header>Test2</header>
    <rec>Rec001</rec>
</exception>

From the above tags i'm generating table data with 3 columns as defined above.
My requirement is to split table for every <header> value
For the above example, i have to get 2 tables, first with two rows since <header> value is same for two <exception> tags and second with 1 row.
How can i accomplish this grouping? Can anyone help?

mhkay · January 6th, 2009, 08:46 AM

In XSLT 2.0, use the xsl:for-each-group instruction.

If you are stuck with XSLT 1.0, use Muenchian Grouping. Look it up in your favourite XSLT textbook or google for it.

mrame · January 7th, 2009, 03:09 AM

Try this:

Code:

<xsl:template match="root">

<xsl:for-each-group select="exception" group-by="header">
<table> 
<xsl:copy-of select="current-group()/rec"></xsl:copy-of>
</table>
</xsl:for-each-group>

</xsl:template>