Recipe showing how to Transform a table or set of tables

Sample Tables

Annotated Query

%XSLTSTART{id="%WEB%" benchmark="off" debug="off" }% 
 <xsl:stylesheet version="1.0" 
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="/">
 <table border="1">
 <tr><th>Title</th><th>Author</th></tr>
 <xsl:apply-templates select="/twiki/web/topic/data/tables/table/row[position()=1]/field[@type='title' and position()=1 and text()='Author']/../../row">

     <xsl:sort select="field[2]"/>

 </xsl:apply-templates>
 </table>
</xsl:template>


<xsl:template match="row">

    <xsl:if test="./field[1][@type='data']">

    <tr>         
       <td><xsl:value-of select="./field[2]"/></td>
        <td><xsl:value-of select="./field[1]"/></td>
    </tr>
    </xsl:if>

  </xsl:template>
  </xsl:stylesheet>
%XSLTEND%

XSLT Demo Transformed Table

The above tables has been transformed in 3 ways

1. They have been combined
2. The Author and Title columns have been swapped
3. The entries have been sorted by Title

%XSLTSTART{id="Plugins" benchmark="off" debug="off" }% <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:value-of select="./field[2]"/> <xsl:value-of select="./field[1]"/>

%XSLTEND%