xslt sorting by attribute

[jnoster]

Hey guys,
I've used the Muenchian Method for sorting and grouping but I've not had any success in using it to group by an attribute. I'm hoping someone here has had this experience and made it work.

Here's a node example from the xml...

<Products>
    <itm num="123456">
        <properties oid="3897936" cat="8" type="Stuff" series="My Series"/>
        <legacy brand="MyOldBrand" oldNum="654321"/>
    </itm>
</Products>

I'm needing to get a list of all the legacy/@brands that are in the data file

Here's the portion of xslt I've been attempting to do this with...

<xsl:key name="ProdByBrand" match="itm" use="legacy/@brand"/>

  <xsl:template match="Products"><xsl:for-each select="itm/legacy[generate-id() = generate-id(key('ProdByBrand', /@brand)[1])]"><xsl:value-of select="/@brand" />|</xsl:for-each></xsl:template>

Any help would be appreciated.
Thanks!

[jnoster]

Thanks for all the help

I found a solution that works. I knew it was just a matter of getting it all configured just right.

Here it is

<xsl:key name="ProdByBrand"  match="//legacy" use="@brand" />
  <xsl:template match="Products"><xsl:for-each select="itm/legacy[generate-id() = generate-id(key('ProdByBrand', @brand)[1])]"><xsl:value-of select="@brand" />|</xsl:for-each>
</xsl:template>