XSL: Display distinct values

elayaraja.s · July 17th, 2008, 06:42 AM

Hi,

Could any one help how to display the distinct values using XSL 1.0,

  <Invoice>
            <InvoiceItem CT="A" >
                        <Set>
                           <Att Ty="TM" Id="LC" />
                        </Set>
            </InvoiceItem>

            <InvoiceItem CT="A" >
                        <Set>
                           <Att Ty="TM" Id="LC" />
                        </Set>
            </InvoiceItem>

            <InvoiceItem CT="S" >
                        <Set>
                            <Att Ty="TM" Id="CC" />
                        </Set>
            </InvoiceItem>
  <Invoice>

Expected output:
          LC
          CC

Output Should not be LC LC CC

XSL file :

         <Invoice>
            <xsl:for-each select="InvoiceItem[@CT='A' or @CT='S']/Set/Att[@Ty='TM']">
                        <xsl:value-of select="@Id"/>
            </xsl:for-each>
        </Invoice>

Could any one guide to get the distict values of @Id â¦â¦â¦

Martin Honnen · July 17th, 2008, 07:00 AM

Use Muenchian grouping and then access the first item in each group:

Code:

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

  <xsl:output method="text"/>

  <xsl:key name="by-id"
           match="Att[@Ty = 'TM']"
           use="@Id"/>

  <xsl:template match="/">
    <xsl:for-each select="Invoice/InvoiceItem/Set/Att[@Ty = 'TM'][generate-id() = generate-id(key('by-id', @Id)[1])]">
      <xsl:value-of select="concat(@Id, '#10;')"/>
    </xsl:for-each>
  </xsl:template>

</xsl:stylesheet>

--
Martin Honnen
Microsoft MVP - XML