Display only unique Nodes

kylektran · July 16th, 2009, 03:13 PM

I have a list of XML with assignmentdescriptions that are redundant (Midterm twice), how can I filter them out to only display the unique ones only.

<Data>
<CategoryDescription>Midterm</CategoryDescription>
<CategoryWeight>25.0000</CategoryWeight>
<AssignmentDescription>Midterm</AssignmentDescription>
<StudentWeightedScore>19.200000</StudentWeightedScore>
</Data>
<Data>
<CategoryDescription>Midterm</CategoryDescription>
<CategoryWeight>230.0000</CategoryWeight>
<AssignmentDescription>Midterm</AssignmentDescription>
<StudentWeightedScore>19.200000</StudentWeightedScore>
</Data>
<Data>
<CategoryDescription>Midterm</CategoryDescription>
<CategoryWeight>20.0000</CategoryWeight>
<AssignmentDescription>Homework 1</AssignmentDescription>
<StudentWeightedScore>19.200000</StudentWeightedScore>
</Data>

Martin Honnen · July 17th, 2009, 08:41 AM

With XSLT 2.0 you can do e.g.

Code:

<xsl:for-each-group select="//Data" group-by="AssignmentDescription">
  <!-- now here the first Data element in each group is the context node 
         so you can do e.g.-->
  <xsl:copy-of select="."/>
  <!-- to output the first Data element in each group or e.g. -->
  <xsl:apply-templates select="."/>
  <!-- to process the first Data element in each group -->
</xsl:for-each-group>

With XSLT 1.0 you would need to use Muenchian grouping: http://www.jenitennison.com/xslt/grouping/muenchian.xml