Hi,
I am very new to XSL and am in desperate need of some help
Part of what I need to do is to get a COUNT DISTINCT on my XML file. (I have attached a chunk of the XML below). I know that this could be done in the stored procedure that is querying the tables but that is a really complicated query and I dont want to fiddle with it.

I want a new variable created in my XSLT which will return the count distinct of the different CGPC variations of the CSCI (SCE_DPTC, computer science) records. For example in this XML file i would like the return count to be 3 as there are 3 seperate and distinct SCE_CGPC's.

This is a chunk of the XML file

<z:row SCE_DPTC='CSCI' DPT_NAME='Computer Science (Physical Sciences School)' SCE_CGPC='PGRE' '

 <z:row SCE_DPTC='CSCI' DPT_NAME='Computer Science (Physical Sciences School)' SCE_CGPC='PGRE'

 <z:row SCE_DPTC='CSCI' DPT_NAME='Computer Science (Physical Sciences School)' SCE_CGPC='PGTM'

 <z:row SCE_DPTC='CSCI' DPT_NAME='Computer Science (Physical Sciences School)' SCE_CGPC='PGTM'

 <z:row SCE_DPTC='CSCI' DPT_NAME='Computer Science (Physical Sciences School)' SCE_CGPC='PGTM'

 <z:row SCE_DPTC='CSCI' DPT_NAME='Computer Science (Physical Sciences School)' SCE_CGPC='UGID'

 <z:row SCE_DPTC='CSCI' DPT_NAME='Computer Science (Physical Sciences School)' SCE_CGPC='UGID'


Any help would be greatly appreciated,

Many thanks,
Chris Cash

 

you are lucky, because
you could do it with the newest "XQuery 1.0 and XPath 2.0 Functions and Operators" spec.

have a look at the function "distinct-values"

at http://www.w3.org/TR/xpath-functions/

Hi markus,

Thanks for the reply but I dont think that I have the new Xpath 2.0. Does anyone else know of an alternative method of getting around the problem?

Thanks,
Chris

If you are using XSLT 2.0, use xsl:for-each-group, or the distinct-values() function.

If you are using 1.0, use Muenchian grouping as described at http://www.jenitennison.com/xslt/grouping

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