XSLT 1.0 Group By

by

Muenchian grouping is the best approach; something like:

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl">

  <xsl:output method="xml" indent="yes"/>      
  <xsl:key name="groups" match="/results/result" use="Store" />

  <xsl:template match="/results">
    <xsl:apply-templates select="result[generate-id() = generate-id(key('groups', Store)[1])]"/>
  </xsl:template>
  <xsl:template match="result">
    <h1><xsl:value-of select="Store"/></h1>
    <table id="{Store}">
      <tr class="heading">
        <th scope="col">Member Id</th>
        <th scope="col">First Name</th>
        <th scope="col">Last Name</th>
      </tr>
      <xsl:for-each select="key('groups', Store)">
        <tr>
          <td><xsl:value-of select="MemberLogin"/></td>
          <td><xsl:value-of select="MemberFirstName"/></td>
          <td><xsl:value-of select="MemberLastName"/></td>
        </tr>
      </xsl:for-each>
    </table>
  </xsl:template>
</xsl:stylesheet>

More Related Contents:

  1. XSLT Transform doesn’t work until I remove root node
  2. XML to CSV Using XSLT
  3. How to fix error: The markup in the document following the root element must be well-formed
  4. XSLT not working in web browser
  5. Current node vs. Context node in XSLT/XPath?
  6. XPath select all elements between two specific elements
  7. How to change or reassign a variable in XSLT?
  8. How do I remove the BOM character from my xml file [duplicate]
  9. Removing duplicate elements with XSLT
  10. How do you output the current element path in XSLT?
  11. Add CDATA to an xml file
  12. How to mimic copy-namespaces=”no” in XSLT 1.0?
  13. Finding the difference between two dateTimes in XSLT
  14. how to Merge two xml files with XSLT
  15. For loops vs. apply-templates
  16. Use ends with in XSLT v1.0
  17. Concatenate multiple node values in xpath
  18. how to find the current date in XSLT 1.0
  19. What browsers support XSLT 2.0?
  20. XSLT – remove whitespace from template
  21. How to ‘select’ from XML with namespaces?
  22. In XSLT how do you test to see if a variable exists?
  23. XSLT 2.0 to convert CSV to XML format
  24. XSLT to order attributes
  25. How do I generate a comma-separated list with XSLT/XPath?
  26. XSL – rounding/format-number problem
  27. Converting XML to escaped text in XSLT
  28. How do I display XML using an XSLT document, in a Delphi app?
  29. XSLT Transform XML with Namespaces
  30. XSLT – Comparing preceding-sibling’s elements with current’s node element

Leave a Comment