[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] xsl grouping problem
I have the following xml file that I want to use to create a table with the values in the format below. I have some xsl I have been trying but I cant get the following-sibling to quite work right. Any suggestions?? Thanks!! XML <?xml version="1.0"?> <DATABASE> <ID>306030300570011572</ID> <TYPE>20</TYPE> <REP>CKCK</REP> <SYMBOL>OMCL</SYMBOL> <ID>306030300570011573</ID> <TYPE>20</TYPE> <REP>CKCK</REP> <SYMBOL>ORCL</SYMBOL> <ID>306030300570011571</ID> <TYPE>20</TYPE> <REP>CKCK</REP> <SYMBOL>TLCV</SYMBOL> <ID>306030300570011572</ID> <TYPE>20</TYPE> <REP>CKCK</REP> <SYMBOL>OMCL</SYMBOL> <ID>306030300570011573</ID> <TYPE>20</TYPE> <REP>CKCK</REP> <SYMBOL>ORCL</SYMBOL> ......... <ID>306030300570011571</ID> <TYPE>20</TYPE> <REP>CKCK</REP> <SYMBOL>TLCV</SYMBOL> <ID>306030300570011572</ID> <TYPE>18</TYPE> <REP>CKCK</REP> <SYMBOL>OMCL</SYMBOL> <ID>306030300570011573</ID> <TYPE>18</TYPE> <REP>CKCK</REP> <SYMBOL>ORCL</SYMBOL> <ID>306030300570011571</ID> <TYPE>20</TYPE> <REP>CKCK</REP> <SYMBOL>TLCV</SYMBOL> </DATABASE> XSL <xsl:variable name="symbol" select="DATABASE/SYMBOL"/> <xsl:variable name="type" select="DATABASE/TYPE"/> <xsl:for-each select="DATABASE/ID[position() mod 3 = 1]"> <xsl:variable name="position" select="position()"/> <tr> <td> <xsl:value-of select="."/>-<xsl:value-of select="$type"/>- <xsl:value-of select="$symbol[$position]"/> </td> <xsl:for-each select="following-sibling::node()[position() < 3]"> <td> <xsl:value-of select="."/>-<xsl:value-of select="$type"/>- <xsl:value-of select="$symbol[$position]"/> </td> </xsl:for-each> </tr> </xsl:for-each> Desired html <table> <tr> <td>IDVALUE - TYPEVALUE - SYMBOVALUEL</td> <td>IDVALUE - TYPEVALUE - SYMBOVALUEL</td> <td>IDVALUE - TYPVALUEE - SYMBOVALUEL</td> </tr> <tr> <td>IDVALUE - TYPEVALUE - SYMBOLVALUE</td> <td>IDVALUE - TYPEVALUE - SYMBOLVALUE</td> <td>IDVALUE - TYPEVALUE - SYMBOLVALUE</td> </tr> ................... <tr> <td>IDVALUE - TYPEVALUE - SYMBOLVALUE</td> <td>IDVALUE - TYPEVALUE - SYMBOLVALUE</td> <td>IDVALUE - TYPEVALUE - SYMBOLVALUE</td> </tr> </table>
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|