RE: Matching similar rows in a table

FAQ,

> I want to transform the below source xml to the destination xml with
> a XSLT script. I run into problems trying to generate the
> <chapter></chapter> tags because there is no structural textual
> "signal" in the source XML to match the start/end of a chapter.
>
> The source XML is the export from a DB in the form of a table. Each
> page is in a row, only the first page has the chapter title, in the
> other page that column contains no data.
>
> The XSLT script has to pick up the special first row, create the
> chapter and name tags and insert the pages for the chapter until
> another special first row is detected.
>
> Alternatively I could generate XML which has the chapter name in each
> first column in the page row. Then the XSLT script will has to detect
> a change in the content of the first column and start a new chapter.
>
> How can I do this in XSLT?

A grouping problem, see <http://jenitennison.com/xslt/grouping>.

  <xsl:template match="*[row]">
    <xsl:for-each select="row[col[1]/node()]">
      <chapter>
        <name>
          <xsl:value-of select="col[1]"/>
        </name>
        <xsl:apply-templates select="."/>
      </chapter>
    </xsl:for-each>
  </xsl:template>
  <xsl:template match="row">
    <page>
      <content>
        <xsl:value-of select="col[3]"/>
      </content>
    </page>
    <xsl:apply-templates
select="following-sibling::row[1][not(col[1]/node())]"/>
  </xsl:template>

Cheers,

Jarno - Front Line Assembly: Plasticity