how to compare xml elemets in xslt

[suji]

hi all,
here is xml file.....
<root>
<Xmltype>
<owner NAME="Legal Entity 1"></owner>
<LegalEntity NAME="Legal Entity 1"></LegalEntity>
<lob NAME="Line Of Business 1"></lob>
<Formula>A</Formula>
<Formula>B</Formula>
</Xmltype>
<Xmltype>
<owner NAME="Legal Entity 1"></owner>
<LegalEntity NAME="Legal Entity 1"></LegalEntity>
<lob NAME="Line Of Business 1"></lob>
<Formula>c</Formula>
<Formula>D</Formula>
<Formula>B</Formula>
</Xmltype>
<Xmltype>
<owner NAME="Legal Entity 1"></owner>
<LegalEntity NAME="Legal Entity 1"></LegalEntity>
<lob NAME="Line Of Business 2"></lob>
<Formula>A</Formula>
</Xmltype>
<Xmltype>
<owner NAME="Legal Entity 1"></owner>
<LegalEntity NAME="Legal Entity 1"></LegalEntity>
<lob NAME="Line Of Business 2"></lob>
<Formula >B</Formula>
</Xmltype>
<Xmltype>
<owner NAME="Legal Entity 1"></owner>
<LegalEntity NAME="Legal Entity 1"></LegalEntity>
<lob NAME="Line Of Business 1"></lob>
<Formula>F</Formula>
</Xmltype>

</root>

I need XSLT for this.........
output should obtain like in HTML by using XSLT:

LegalEntityOwner:Legal Entity 1
LegalEntityName:LegalEntity
LobName:Line Of Business 1
Formula:A
Formula:B
Formula:C
Formula:D
Formula:B
Formula:F

LegalEntityOwner:Legal Entity 1
LegalEntityName:LegalEntity
LobName:Line Of Business 2
Formula:A
Formula:B


pleas can any one help!!!!

[jkmyoung]

Muenchian grouping
http://www.jenitennison.com/xslt/groupi ... chian.html

Code: Select all

<xsl:key name="xmltypesByLob" match="Xmltype" use="lob/@NAME"/>



<xsl:for-each select="/root/Xmltype[count(.|key('xmltypesByLob', lob/@NAME)[1]) = 1]">

  <xsl:text>LegalEntityOwner:</xsl:text>

  <xsl:value-of select="owner/@NAME"><br/>

  <xsl:text>LegalEntityName:</xsl:text>

  <xsl:value-of select="LegalEntity/@NAME"><br/>

  <xsl:text>LobName:</xsl:text>

  <xsl:value-of select="lob/@NAME"><br/>

  <xsl:for-each select="key('xmltypesByLob',lob/@name)/Formula">

     <xsl:text>Formula:</xsl:text>

     <xsl:value-of select="."/><br/>

  </xsl:for-each>

  <br/>

</xsl:for-each>

[suji]

thanx.........