Oxygen XML Forum

Posted: **Thu Feb 28, 2008 7:06 pm**

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!!!!

Posted: **Fri Feb 29, 2008 6:28 pm**

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>

Posted: **Sun Mar 02, 2008 9:03 am**

thanx.........

Oxygen XML Forum

how to compare xml elemets in xslt

how to compare xml elemets in xslt

Re: how to compare xml elemets in xslt

Re: how to compare xml elemets in xslt