Displaying nested XML in groups

[kohinoor24]

Hi,
I have some example xml:

<Root>
<Rec>
<RecType>Type A</RecType>
<Words>testing output of A</Words>
</Rec>
<Rec>
<RecType>Type B</RecType>
<Words>testing output of B</Words>
</Rec>
<Rec>
<RecType>Type A</RecType>
<Words>testing output of A again</Words>
</Rec>
</Root>

I'm basically trying to output each 'RecType' as a heading with the corresponding 'Words' underneath. Using a xsl:for-each only results in all of the results being listed one after the other, whereas I actually want them grouped (i.e. Type A results and then Type B).

I did:

<xsl:for-each select="Rec/RecType">
<table>
<tr>
<td><xsl:value-of select="." /></td>
<td><xsl:value-of select="../Words" /></td>
</tr>
</table>
</xsl:for-each>

Any help appreciated.

Thanks.

 

[CubeE101]

either:

<xsl:for-each select="Rec"> 
 <table> 
  <tr> 
   <td><xsl:value-of select="RecType" /></td> 
   <td><xsl:value-of select="Words" /></td> 
  </tr> 
 </table> 
</xsl:for-each>

Or:

<table> 
 <tr> 
  <xsl:for-each select="Rec"> 
   <th><xsl:value-of select="RecType" /></th> 
  </xsl:for-each>
 </tr> 
 <tr> 
  <xsl:for-each select="Rec"> 
   <td><xsl:value-of select="Words" /></td> 
  </xsl:for-each>
 </tr> 
</table>

But there are easier and more efficient ways to set up table data...

Such as if you want to use the tagname as the header...
Look into node-name(node)

you could use something like:

<table> 
 <tr> 
  <xsl:for-each select="Rec[1]/*"> 
   <th><xsl:value-of select="node-name(.)" /></th> 
  </xsl:for-each>
 </tr> 
 <xsl:for-each select="Rec"> 
  <tr> 
   <xsl:for-each select="*"> 
    <td><xsl:value-of select="RecType" /></td> 
    <td><xsl:value-of select="Words" /></td> 
   </xsl:for-each>
  </tr> 
 </xsl:for-each>
</table>

Although, you should use keys in the above scenario, to avoid problems from missing or out-of-order elements...

http://www.w3schools.com/xsl/el_key.asp

Visit My Site
PROGRAMMER: Red-eyed, mumbling mammal capable of conversing with inanimate objects.

 

[kohinoor24]

Thank you for the reply, the code you suggested did generate different output but I should have been clearer in my original post (my fault, sorry!).

The output I'm currently getting is:

Type A testing output of A
Type B testing output of B
Type A testing output of A again


The output I want to generate is (lists 'Type A' entries together and so on):

Type A testing output of A
Type A testing output of A again
Type B testing output of B

 

[CubeE101]

check into <xsl:sort>

http://www.w3schools.com/xsl/el_sort.asp

Visit My Site
PROGRAMMER: Red-eyed, mumbling mammal capable of conversing with inanimate objects.

 

[kohinoor24]

I got it to work!

Thanks for your help CubeE101.