XML, XSLT and XPATH

Repeat header when NODE changes (compare with previous-sibling)

•

Join Date: Sep 2008

Posts: 1

Reputation: qwix123 is an unknown quantity at this point

Solved Threads: 0

qwix123

Offline

Newbie Poster

Repeat header when NODE changes (compare with previous-sibling)

Sep 16th, 2008

Hello,
this is my XML:

 Help with Code Tags 
 XML, XSLT and XPATH Syntax (Toggle Plain Text) 
<OPTIONS>
 
<ROW NUM="1">
<ROW_NUM>1</ROW_NUM>
<INVOICE_NUMBER>000001</INVOICE_NUMBER>
<ID>144795</ID>
<CUS_UK>20544</CUS_UK>
<DESC_LONG>KELEME</DESC_LONG>
</ROW>
 
<ROW NUM="2">
<ROW_NUM>1</ROW_NUM>
<INVOICE_NUMBER>000001</INVOICE_NUMBER>
<ID>69449</ID>
<CUS_UK>15249</CUS_UK>
<DESC_LONG>PETRIMEX</DESC_LONG>
</ROW>
 
<ROW NUM="3">
<ROW_NUM>1</ROW_NUM>
<INVOICE_NUMBER>000001</INVOICE_NUMBER>
<ID>4125</ID>
<CUS_UK>15249</CUS_UK>
<DESC_LONG>PETRIMEX</DESC_LONG>
</ROW>
 
<ROW NUM="4">
<ROW_NUM>3</ROW_NUM>
<INVOICE_NUMBER>000002</INVOICE_NUMBER>
<ID>4152</ID>
<CUS_UK>15249</CUS_UK>
<DESC_LONG>PETRIMEX</DESC_LONG>
</ROW>
 
<ROW NUM="5">
<ROW_NUM>3</ROW_NUM>
<INVOICE_NUMBER>000002</INVOICE_NUMBER>
<ID>69486</ID>
<CUS_UK>15249</CUS_UK>
<DESC_LONG>PETRIMEX</DESC_LONG>
</ROW>
</OPTIONS>
<OPTIONS>

<ROW NUM="1">
<ROW_NUM>1</ROW_NUM>
<INVOICE_NUMBER>000001</INVOICE_NUMBER>
<ID>144795</ID>
<CUS_UK>20544</CUS_UK>
<DESC_LONG>KELEME</DESC_LONG>
</ROW>

<ROW NUM="2">
<ROW_NUM>1</ROW_NUM>
<INVOICE_NUMBER>000001</INVOICE_NUMBER>
<ID>69449</ID>
<CUS_UK>15249</CUS_UK>
<DESC_LONG>PETRIMEX</DESC_LONG>
</ROW>

<ROW NUM="3">
<ROW_NUM>1</ROW_NUM>
<INVOICE_NUMBER>000001</INVOICE_NUMBER>
<ID>4125</ID>
<CUS_UK>15249</CUS_UK>
<DESC_LONG>PETRIMEX</DESC_LONG>
</ROW>

<ROW NUM="4">
<ROW_NUM>3</ROW_NUM>
<INVOICE_NUMBER>000002</INVOICE_NUMBER>
<ID>4152</ID>
<CUS_UK>15249</CUS_UK>
<DESC_LONG>PETRIMEX</DESC_LONG>
</ROW>

<ROW NUM="5">
<ROW_NUM>3</ROW_NUM>
<INVOICE_NUMBER>000002</INVOICE_NUMBER>
<ID>69486</ID>
<CUS_UK>15249</CUS_UK>
<DESC_LONG>PETRIMEX</DESC_LONG>
</ROW>
</OPTIONS>

What I need to do is repeat some header everytime ROW_NUM changes. I came this far:

Help with Code Tags

(Toggle Plain Text)

<xsl:for-each select="OPTIONS/ROW">
  <xsl:choose>
    <xsl:when test="position()=1 or preceding-sibling::ROW_NUM/text()[1] != ./ROW_NUM/text()">
        <!-- this should match the first row and then every row where ROW_NUM is different form previous -->
   </xsl:when>
   <xsl:otherwise>
     <!-- this should match the rest -->
   <xsl:otherwise>
 </xsl:choose>
</xsl:for-each>

I'm having trouble with writing the condition in red. Can someone give me an advice?
Thanks a lot!

Last edited by qwix123; Sep 16th, 2008 at 5:34 am. Reason: mistype