Prevent displaying duplicate infromation in xsl

Indy1304 · July 28th, 2008, 11:03 AM

I wonder if you could help me solve an xsl problem.

I have the following xml string:

<data>
            <project code=â1â name=âcompany1â costName=âcost1â supplierName=âABC Ltdâ/>

            <project code=â1â name=âcompany1â costName=âcost2â supplierName=âxxx Ltdâ/>

            <project code=â2â name=âcompany2â costName=âcost1â supplierName=123 Ltdâ/>

</data>

What I really need to do is produce a report that shows the supplier name for each company. The cost name will be a column on the report and not a row.

Eg

Company Cost1 Cost2

Company1 ABC Ltd XXX Ltd

Company2 123 Ltd

Can it be done? If so, how?

Thanks

Indy

mhkay · July 28th, 2008, 11:13 AM

This problem is known as grouping. In XSLT 2.0 it's quite easy using the <xsl:for-each-group> instruction. In XSLT 1.0 it's quite tricky, but achievable using the Muenchian grouping technique described at http://www.jenitennison.com/xslt/grouping

Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer's Reference