Thanks for the help David!
I think I have something that will work:
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";>
<xsl:output method="html" version="1.0"
encoding="UTF-8" indent="yes"/>
<xsl:key name="kDate" match="Table" use="date"/>
<xsl:key name="kCustomer" match="Table"
use="concat(date,'+',CustomerName)"/>
<xsl:template match="/NewDataSet">
<html>
<table border="1">
<xsl:for-each select="Table">
<xsl:if test="generate-id(.) =
generate-id(key('kDate', date)[1])">
<tr>
<td colspan="4">
<xsl:value-of
select="date"/>
</td>
</tr>
<xsl:for-each
select="key('kDate', date)">
<xsl:if
test="generate-id(.) =
generate-id(key('kCustomer',concat(date,'+',CustomerName))[1])">
<xsl:for-each
select="key('kCustomer',
concat(date,'+',CustomerName))">
<xsl:if
test="position() = 1">
<tr>
<td>
<input type="checkbox" disabled="true"/>
</td>
<td colspan="2">
<xsl:value-of select="CustomerName"/>
</td>
<td>
<xsl:value-of select="ServiceName"/>
</td>
<td>
<xsl:value-of select="TimesPerDay"/>
</td>
</tr>
</xsl:if>
<xsl:if
test="not(position() = 1)">
<tr>
<td colspan="2"/>
<td>
<xsl:value-of select="ServiceName"/>
</td>
<td>
<xsl:value-of select="TimesPerDay"/>
</td>
</tr>
</xsl:if>
</xsl:for-each>
</xsl:if>
</xsl:for-each>
</xsl:if>
</xsl:for-each>
</table>
</html>
</xsl:template>
</xsl:stylesheet>
--- "M. David Peterson" <m(_dot_)david(_at_)mdptws(_dot_)com> wrote:
generate-id() coupled with key() is only going to
give you the first
instance of each distinct element in a group. With
that information you
can then test each of the elements against this
information and group
them as such. I wish I had the time to look through
your particular
code a bit more and figure out your specific error.
But I do have the
time to copy and paste a quick and simple example
that highlights the
correct process using apply-templates and a passed
parameter containing
all of the ungrouped elements that can then be used
to test against each
distinct group. Let me know if you have any further
questions and if I
don't have the time to help I am confident you will
find several other
list members who will be more than happy to help
out.
Best of luck!
<M:D/>
Sample XML:
<?xml version="1.0"?>
<crayons>
<crayon color="blue" brand="crayola"/>
<crayon color="yellow" brand="generic"/>
<crayon color="violet" brand="generic"/>
<crayon color="violet" brand="crayola"/>
<crayon color="fuscia" brand="crayola"/>
<crayon color="red" brand="generic"/>
<crayon color="red" brand="crayola"/>
<crayon color="blue" brand="generic"/>
<crayon color="green" brand="generic"/>
<crayon color="green" brand="crayola"/>
<crayon color="yellow" brand="crayola"/>
<crayon color="orange" brand="generic"/>
<crayon color="orange" brand="crayola"/>
<crayon color="fuscia" brand="generic"/>
</crayons>
Sample XSLT:
<?xml version="1.0"?>
<xsl:stylesheet
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
version="1.0">
<xsl:key name="brand" match="@brand" use="."/>
<xsl:template match="crayons">
<xsl:apply-templates
select="crayon[generate-id(@brand) =
generate-id(key('brand', @brand))]" mode="brand">
<xsl:with-param name="crayons" select="crayon"/>
</xsl:apply-templates>
</xsl:template>
<xsl:template match="crayon" mode="brand">
<xsl:param name="crayons"/>
<xsl:variable name="brand" select="@brand"/>
Brand: <xsl:value-of select="@brand"/><br/>
<xsl:apply-templates select="$crayons[(_at_)brand =
$brand]" mode="sort"/>
</xsl:template>
<xsl:template match="crayon" mode="sort">
Color: <xsl:value-of select="@color"/><br/>
</xsl:template>
</xsl:stylesheet>
Sample output:
Brand: crayola<br/>
Color: blue<br/>
Color: violet<br/>
Color: fuscia<br/>
Color: red<br/>
Color: green<br/>
Color: yellow<br/>
Color: orange<br/>
Brand: generic<br/>
Color: yellow<br/>
Color: violet<br/>
Color: red<br/>
Color: blue<br/>
Color: green<br/>
Color: orange<br/>
Color: fuscia<br/>
-----Original Message-----
From: James Hunt [mailto:jamesanthonyhunt(_at_)yahoo(_dot_)com]
Sent: Friday, April 09, 2004 2:37 PM
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: Re: [xsl] Grouping and Key Problem
Hi Mukul,
Thanks for all your help, but I'm only getting the
first customer from each date.
Current Output:
12/13/2001
John Water Plant 4
Mail 5
12/14/2001
Jimmy Mail 5
What I need:
12/13/2001
John Water Plant 4
Mail 5
Jimmy Mail 5
12/14/2001
Jimmy Mail 5
Can you tell me what I need to do?
Thanks,
James
--- Mukul Gandhi <mukulgandhi2003(_at_)yahoo(_dot_)co(_dot_)in>
wrote:
Hi James,
I have written the logic specific to your
requirement. Hope its useful.
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";>
<xsl:output method="html" version="1.0"
encoding="UTF-8" indent="yes"/>
<xsl:key name="kDate" match="Table" use="date"/>
<xsl:key name="kCustomer" match="Table"
use="concat(date,'+',CustomerName)"/>
<xsl:template match="/NewDataSet">
<html>
<table border="1">
<xsl:for-each select="Table">
<xsl:if test="generate-id(.) =
generate-id(key('kDate', date)[1])">
<tr>
<td colspan="4">
<xsl:value-of select="date"/>
</td>
</tr>
<xsl:for-each select="key('kDate', date)">
<xsl:if test="generate-id(.) =
generate-id(key('kCustomer',concat(date,'+',CustomerName))[1])">
<xsl:if test="position() = 1">
<tr>
<td/>
<td>
<xsl:value-of select="CustomerName"/>
</td>
<td>
<xsl:value-of select="ServiceName"/>
</td>
<td>
<xsl:value-of select="TimesPerDay"/>
</td>
</tr>
</xsl:if>
<xsl:if
test="not(position() = 1)">
<tr>
<td colspan="2"/>
<td>
<xsl:value-of select="ServiceName"/>
</td>
<td>
<xsl:value-of select="TimesPerDay"/>
</td>
</tr>
</xsl:if>
</xsl:if>
</xsl:for-each>
</xsl:if>
</xsl:for-each>
</table>
</html>
</xsl:template>
</xsl:stylesheet>
Regards,
Mukul
--- James Hunt <jamesanthonyhunt(_at_)yahoo(_dot_)com>
wrote:
I'm having problems with grouping and the use of
keys
can anyone tell me what I'm doing wrong here. I
have
two records of John on the 12/13/2001 They
shouldn't
display separated. How can I make this tranform
into
something like this:
12/13/2001
John
Water Plant
Mail
12/13/2001
Jimmy
Mail
Right now it is giving this:
12/13/2001
John
Water Plant
Mail
John
Water Plant
Mail
12/13/2001
Jimmy
Mail
XML File
<?xml version="1.0" encoding="UTF-8"?>
<NewDataSet>
<Table>
<mymonth>12</mymonth>
<myday>13</myday>
<myyear>2001</myyear>
<CustomerName>John</CustomerName>
<date>12/13/2001</date>
<TimesPerDay>4</TimesPerDay>
<ServiceName>Water Plant</ServiceName>
</Table>
<Table>
<mymonth>12</mymonth>
<myday>13</myday>
<myyear>2001</myyear>
<CustomerName>John</CustomerName>
<date>12/13/2001</date>
<TimesPerDay>5</TimesPerDay>
<ServiceName>Mail</ServiceName>
</Table>
<Table>
<mymonth>12</mymonth>
<myday>13</myday>
<myyear>2001</myyear>
<CustomerName>Jimmy</CustomerName>
<date>12/13/2001</date>
<TimesPerDay>5</TimesPerDay>
<ServiceName>Mail</ServiceName>
</Table>
<Table>
<mymonth>12</mymonth>
<myday>14</myday>
<myyear>2001</myyear>
<CustomerName>Jimmy</CustomerName>
<date>12/14/2001</date>
<TimesPerDay>5</TimesPerDay>
<ServiceName>Mail</ServiceName>
</Table>
</NewDataSet>
XSLT
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";>
<xsl:output method="html" version="1.0"
indent="yes"/>
<xsl:key name="kCustomer" match="Table"
use="CustomerName"/>
<xsl:key name="kDate" match="Table"
use="date"/>
<xsl:template match="NewDataSet">
<head>
<title>Employee's Week Schedule</title>
<link href="../css/reports.css"
type="text/css"
rel="stylesheet" />
</head>
<table border="0" cellpadding="4"
style="border-collapse:collapse;" width="100%">
<tr>
<td colspan="1">
<b>Customer Name</b>
</td>
<td colspan="1">
<b>Service Name</b>
</td>
<td colspan="2">
<b>Times Per Day</b>
</td>
</tr>
<xsl:apply-templates
select="Table[generate-id()
=
generate-id(key('kDate', date))]" mode="row1"/>
</table >
</xsl:template>
<xsl:template match="Table" mode="row1">
<tr>
<td colspan="4">
<div
style="background-color:red"><xsl:value-of
select="date"/></div>
<xsl:apply-templates
select="parent::NewDataSet/Table[date =
current()/date][CustomerName = key('kCustomer',
CustomerName)/CustomerName]" mode="row2"/>
</td>
</tr>
</xsl:template>
<xsl:template match="Table" mode="row2">
<tr>
<td colspan="4">
<hr/>
<xsl:value-of select="CustomerName"/>
<xsl:apply-templates
select="parent::NewDataSet/Table[date =
current()/date][CustomerName =
current()/CustomerName][ServiceName]"
mode="row3"/>
</td>
</tr>
</xsl:template>
<xsl:template match="Table" mode="row3">
<tr>
<td />
<td colspan="1">
<xsl:value-of select="ServiceName"/>
</td>
<td colspan="2">
<xsl:value-of select="TimesPerDay"/>
</td>
</tr>
</xsl:template>
</xsl:stylesheet>
=====
Home: (513) 661 - 8007
Cell: (513) 884 - 4868
Email: jamesanthonyhunt(_at_)yahoo(_dot_)com
__________________________________
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway
http://promotions.yahoo.com/design_giveaway/
--+------------------------------------------------------------------
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>
--+--
________________________________________________________________________
Yahoo! India Matrimony: Find your partner online.
http://yahoo.shaadi.com/india-matrimony/
--+------------------------------------------------------------------
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>
--+--
=====
Home: (513) 661 - 8007
Cell: (513) 884 - 4868
Email: jamesanthonyhunt(_at_)yahoo(_dot_)com
__________________________________
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway
http://promotions.yahoo.com/design_giveaway/
--+------------------------------------------------------------------
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>
--+--
--+------------------------------------------------------------------
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>
--+--
=====
Home: (513) 661 - 8007
Cell: (513) 884 - 4868
Email: jamesanthonyhunt(_at_)yahoo(_dot_)com
__________________________________
Do you Yahoo!?
Yahoo! Tax Center - File online by April 15th
http://taxes.yahoo.com/filing.html