Hello,
I'm using IE6 & MSXML to transform,sort and count 2 separate xml docs,
but the results are not as I expected.
As a beginner, I obviously have understood something wrong, I'm using
the so-called "Muenchian method" here (...wtg for the XSLT 2.0 to MSXML)
I would be very appreciated if some xslt expert could give me a clue
what I'm doing wrong.
Below are xml, xsl, results I got and results I wanted :
-------------------------
net_sample1.xml:
<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="net_sample.xsl"?>
<List>
<row>
<row_id>A1</row_id>
<row_status>New</row_status>
</row>
<row>
<row_id>A2</row_id>
<row_status>New</row_status>
</row>
<row>
<row_id>A2</row_id>
<row_status>Old</row_status>
</row>
</List>
-------------------------
net_sample2.xml:
<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="net_sample.xsl"?>
<List>
<row>
<row_id>A1</row_id>
<row_status>New</row_status>
</row>
<row>
<row_id>A1</row_id>
<row_status>New</row_status>
</row>
<row>
<row_id>A2</row_id>
<row_status>Old</row_status>
</row>
</List>
------------------------
net_sample.xsl :
<?xml version="1.0"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform" >
<xsl:key name="rowkey" match="row"
use="row_id" />
<xsl:key name="rowkey_old" match="row[row_status='Old']"
use="row_id" />
<xsl:key name="rowkey_new" match="row[row_status='New']"
use="row_id" />
<xsl:template match="/">
<html>
<head></head>
<body>
<xsl:variable name="all_docs" select="document('net_sample1.xml'
)/List/row | document('net_sample2.xml' )/List/row "/>
<table border="0" bgcolor="ivory">
<xsl:for-each select="$all_docs">
<xsl:sort select="row_id"/>
<xsl:for-each select="current()[count(. | key('rowkey', row_id)[1]) =
1]">
<tr>
<td><xsl:value-of select="row_id"/></td>
<th>Old rows = </th>
<td><xsl:value-of select="count( key('rowkey_old',row_id) )"/></td>
<th>New rows = </th>
<td><xsl:value-of select="count( key('rowkey_new',row_id) )"/></td>
</tr>
</xsl:for-each>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
------------
Result:
A1 Old rows=0 New rows=1
A1 Old rows=0 New rows=2
A2 Old rows=1 New rows=1
A2 Old rows=1 New rows=0
------------------------------------------
The result I expected to see :
A1 Old rows=0 New rows=3
A2 Old rows=2 New rows=1
Any ideas how to reach the wanted result ?
Regards, Tapio
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--