how to apply group by on xslt elements

by

In XSLT 1.0, using Muenchian grouping.

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

    <xsl:output method="xml" indent="yes" />

    <xsl:key name="division" match="User" use="@Division" />

    <xsl:template match="Users">
        <AllUsers>
            <xsl:apply-templates select="User[generate-id(.)=generate-id(key('division',@Division)[1])]"/>
        </AllUsers>
    </xsl:template>

    <xsl:template match="User">
        <Division value="{@Division}">
            <xsl:for-each select="key('division', @Division)">
                <User>
                    <id><xsl:value-of select="@id" /></id>
                    <name><xsl:value-of select="@name" /></name>
                </User>
            </xsl:for-each>
        </Division>
    </xsl:template>

</xsl:stylesheet>

In XSLT 2.0, use xsl:foreach-group

<xsl:output method="xml" indent="yes" />

<xsl:template match="Users">
    <AllUsers>
        <xsl:for-each-group select="User" group-by="@Division">
            <Division value="{@Division}">
                <xsl:for-each select="current-group()">
                    <User>
                        <id><xsl:value-of select="@id" /></id>
                        <name><xsl:value-of select="@name" /></name>
                    </User>
                </xsl:for-each>
            </Division>
        </xsl:for-each-group>
    </AllUsers>
</xsl:template>

More Related Contents:

  1. XSLT 3-level grouping on attributes
  2. Database to PDF [closed]
  3. XSLT with XML source that has a default namespace set to xmlns
  4. XSLT string replace
  5. Why does XSLT output all text by default?
  6. How can I make XSLT work in chrome?
  7. What are the differences between ‘call-template’ and ‘apply-templates’ in XSL?
  8. How to use XSLT to create distinct values
  9. Can an XSLT insert the current date?
  10. Producing a new line in XSLT
  11. Check if a string is null or empty in XSLT
  12. Using an HTML entity in XSLT (e.g.  )
  13. XSLT: How to change an attribute value during ?
  14. Replace special characters in XSLT
  15. How to execute XSLT 2.0 with ant?
  16. XSLT generate UUID
  17. Please suggest for XSLT code for Table rowspan and colspan issues
  18. Tokenizing and sorting with XSLT 1.0
  19. Conver EDT to GMT in XSLT 1.0
  20. Why do indexes in XPath start with 1 and not 0?
  21. XPath find if node exists
  22. dynamic xpath in xslt?
  23. Adding element in middle of xml using xslt
  24. How to concat a string to xsl:value-of select=”…?
  25. Inserting a line break in a PDF generated from XSL FO using
  26. How-to break a for-each loop in XSLT?
  27. Removing empty tags from XML via XSLT
  28. adding attribute to the node
  29. Update the text of an element with XSLT based on param
  30. XSLT Bitwise Logic

Leave a Comment