XSLT: Calculating Across Columns of Table

Newbie · Aug 20, 2006

Suppose that I have an HTML table of numbers, and I need to replace the value of each cell with
itself divided by the total for that column. The best I can think of is as follows:

<xsl:for-each select="tr">
<xsl:copy>
<xsl:for-each select="td">
<xsl:variable name="col" select="position()" />
<xsl:variable name="total" select="sum(../../tr/td[position()=$col])" />
<xsl:copy>
<xsl:value-of select=". div $total" />
</xsl:copy>
</xsl:for-each>
</xsl:copy>
</xsl:for-each>

This is rather verbose (the temporary col variable), and has to be recalculated for each row. Is
there a more concise/efficient way of doing this?

Soren Kuula · Aug 20, 2006

Newbie said:
Suppose that I have an HTML table of numbers, and I need to replace the
value of each cell with itself divided by the total for that column. The
best I can think of is as follows:

Better make that XHTML

The best I can think of is using keys: All 1'st td's will be mapped
under 1 in the k key, all second under 2, etc.... The key is then looked
up (using position()) where needed. Column node selection is thus done,
but the sum is still recomputed.

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
version='1.0'>

<xsl:key name="k" match="td" use="1 + count(preceding-sibling::td)"/>

<xsl:template match="tr">
<tr>
<xsl:apply-templates select="td"/>
</tr>
</xsl:template>

<xsl:template match="td">
<td>
<xsl:value-of select=". div sum(key('k', position()))"/>
</td>
</xsl:template>

</xsl:stylesheet>

Sample input:
<html>
<body>
<table>
<tr>
<td>1</td>
<td>2</td>
</tr>
<tr>
<td>3</td>
<td>4</td>
</tr>
</table>
</body>
</html>

Sample output:

<tr><td>0.25</td><td>0.33333333333333</td></tr>
<tr><td>0.75</td><td>0.66666666666667</td></tr>

(oops that's not even XML --- well a / mathcing template could wrap over
it what it is missing

)

Søren

How to create a JSON array with values from DOM(HTML TABLE) when I click a button using JQuery/Javascript?	0	May 1, 2023
How to create a JSON array with values from DOM(HTML TABLE) when I click a button using JQuery/Javascript?	0	May 1, 2023
Merging tables with XSLT	2	May 29, 2009
Show/Hide HTML Table Columns using SELECT option	1	Nov 9, 2020
XSLT question	4	Oct 18, 2006
XSLT Dynamic Columns (Save my eyebrows!)	0	Oct 12, 2008
Nested Dynamic XSLT Columns (Save my Eyebrows!)	0	Oct 12, 2008
Problem in xml transformation using xslt	0	Nov 25, 2011

XSLT: Calculating Across Columns of Table

Newbie

Soren Kuula

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads