XML to XSLT conversion??

Hannibal · November 24th, 2006, 04:45 AM

As i told, The table structure should be like this. Its just a report which groups the query,condition and the Association_rule. The tables do not have any relation

Hannibal · November 24th, 2006, 05:11 AM

I understand that the input has no relationship with the output that i want. Consider this, a table can have more than 2 or 3 columns, and it varies from table to table. The Query,condition,Association_rule are to be just provided as an output sequentially one after another, even though no relation exists. Hope this helps in understanding

ramesh.kumarm · November 24th, 2006, 05:16 AM

Is that like u r getting this
________________________________________
Table Columns Query Condition Association Rule
Mine Blue Select all 1
         Red
         Green
Others white Insert = 2
         orange
________________________________________

and that u need the insert/=/2 mapped to red.

If so you cannot have a generalized loop.
U need to dig down to fetch the values u need.

thanx

Hannibal · November 24th, 2006, 05:54 AM

yes i am getting like this. But the required output is:
Table Columns Query Condition Association Rule

Mine Blue select all 1
          Red insert = 2
          Green
Others White
          Orange

Hannibal · November 24th, 2006, 05:57 AM

Ramesh can you help me in getting the solution. I really need someone to help me

ramesh.kumarm · November 24th, 2006, 06:44 AM

Well, if this is what youwant then dont loop it...rather pull the values and fix it.

ramesh.kumarm · November 24th, 2006, 06:52 AM

do u need something like thi?

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:template match="/">
        <html>
            <body>
                <table border="1">
                    <tr bgcolor="#9acd32">
                        <th align="left">Table</th>
                        <th align="left">Columns</th>
                        <th align="left">Query</th>
                        <th align="left">Condition</th>
                        <th align="left">Association Rule</th>
                    </tr>
                    <tr>
                        <td><xsl:value-of select="//*/Catalog[1]/TableName"/></td>
                        <td><xsl:value-of select="//*/Catalog[1]/Column1"/></td>
                        <td><xsl:value-of select="//*/Catalog[1]/Query"/></td>
                        <td><xsl:value-of select="//*/Catalog[1]/Condition"/></td>
                        <td><xsl:value-of select="//*/Catalog[1]/Association_rule"/></td>
                    </tr>
                    <tr>
                        <td/>
                        <td><xsl:value-of select="//*/Catalog[1]/Column2"/></td>
                        <td><xsl:value-of select="//*/Catalog[2]/Query"/></td>
                        <td><xsl:value-of select="//*/Catalog[2]/Condition"/></td>
                        <td><xsl:value-of select="//*/Catalog[2]/Association_rule"/></td>
                    </tr>
                    <tr>
                        <td/>
                        <td><xsl:value-of select="//*/Catalog[1]/Column3"/></td>
                    </tr>
                    <tr>
                        <td><xsl:value-of select="//*/Catalog[2]/TableName"/></td>
                        <td><xsl:value-of select="//*/Catalog[2]/Column1"/></td>
                    </tr>
                    <tr>
                        <td/>
                        <td><xsl:value-of select="//*/Catalog[2]/Column2"/></td>
                    </tr>
                </table>
            </body>
        </html>
    </xsl:template>
</xsl:stylesheet>