Subject: RE: [xsl] Grouping question From: "Nishma Jain" <njain@xxxxxxxxxxxx> Date: Fri, 13 Aug 2004 12:58:29 -0600 |
Mukul, Thanks for replying! I solved the problem by adding " ,../../@num" in the key. Now my key is.. <xsl:key name="line-date" match="Statements/Statement/Property/Line" use="concat(substring(@pDate, 6, 2),'-', substring(@pDate, 1, 4),../../@num)" /> I tried your solution and it's working too. Thanks! Nishma -----Original Message----- From: Mukul Gandhi [mailto:mukul_gandhi@xxxxxxxxx] Sent: Thursday, August 12, 2004 10:29 PM To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx Subject: Re: [xsl] Grouping question Hi Nishma, Please try this XSL - <?xml version="1.0"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xalan="http://xml.apache.org/xalan" version="1.0"> <xsl:output method="text" /> <xsl:key name="by-date" match="temp/Line" use="concat(substring(@pDate, 6, 2),'-', substring(@pDate, 1, 4))" /> <xsl:template match="/Statements"> <xsl:for-each select="Statement"> Statement: <xsl:value-of select="@number" /><xsl:text>
</xsl:text> Name: <xsl:value-of select="Property/@name" /><xsl:text>
</xsl:text> <xsl:variable name="rtf"> <temp> <xsl:copy-of select="Property/Line" /> </temp> </xsl:variable> <xsl:for-each select="xalan:nodeset($rtf)/temp/Line"> <xsl:if test="generate-id(.) = generate-id(key('by-date', concat(substring(@pDate, 6, 2),'-', substring(@pDate, 1, 4)))[1])"> <xsl:for-each select="key('by-date', concat(substring(@pDate, 6, 2),'-', substring(@pDate, 1, 4)))"> Date <xsl:value-of select="@pDate" /> amount: <xsl:value-of select="@amount" /><xsl:text>
</xsl:text> </xsl:for-each> MONTH TOTAL : <xsl:value-of select="sum(key('by-date', concat(substring(@pDate, 6, 2),'-', substring(@pDate, 1, 4)))/@amount)" /><xsl:text>
</xsl:text> </xsl:if> </xsl:for-each> </xsl:for-each> </xsl:template> </xsl:stylesheet> Regards, Mukul --- Nishma Jain <njain@xxxxxxxxxxxx> wrote: > Hi, > > I'm having a grouping issue. In my case root tag is > "Statements" and > under Statements I can have multiple Statement tags. > I'm using muenchian > method for grouping but I need to group within a > Statement tag as oppose > to the whole xsl doc. Now within each Statement I > have to calculate > month totals. Since all the months and dates are > dynamic so I'm using > grouping to get a set of amounts according to the > month and year. As you > can see in the output, amounts from the 2nd > statement node are showing > up in the first statement since key is getting > applied to the whole xml > doc. I need to restrict it to the current statement > node only. Is there > any way to do it? How can I specify current id or > any other attribute of > the statement in the key or any other idea??? > > Hope I made myself clear. Attached are my test xml > and xsl scripts. > > Thanks in advance, > Nishma > > My output... > > Statement:1 > Name:AAA > Date 2004-07-09 amount: 1.00 > Date 2004-07-10 amount: 2.00 > Date 2004-07-08 amount: 1.00 > Date 2004-07-19 amount: 3.00 > MONTH TOTAL : 7.00 > Date 2004-08-09 amount: 3.00 > Date 2004-08-10 amount: 4.00 > Date 2004-08-11 amount: 5.00 > Date 2004-08-22 amount: 2.00 > MONTH TOTAL : 14.00 > Statement:2 > Name:BBB > Date 2004-09-10 amount: 4.00 > MONTH TOTAL : 4.00 > > Required output ..... > > Statement:1 > Name:AAA > Date 2004-07-09 amount: 1.00 > Date 2004-07-10 amount: 2.00 > MONTH TOTAL : 3.00 > Date 2004-08-09 amount: 3.00 > Date 2004-08-10 amount: 4.00 > Date 2004-08-11 amount: 5.00 > MONTH TOTAL : 12.00 > Statement:2 > Name:BBB > Date 2004-07-08 amount: 1.00 > Date 2004-07-19 amount: 3.00 > MONTH TOTAL : 4.00 > Date 2004-08-22 amount: 2.00 > MONTH TOTAL : 2.00 > Date 2004-09-10 amount: 4.00 > MONTH TOTAL : 4.00 > > My xml: > > <Statements> > <Statement number="1" total="15"> > <Property name="AAA"> > <Line pDate="2004-07-09" amount="1.00"/> > <Line pDate="2004-07-10" amount="2.00"/> > <Line pDate="2004-08-09" amount="3.00"/> > <Line pDate="2004-08-10" amount="4.00"/> > <Line pDate="2004-08-11" amount="5.00"/> > </Property> > </Statement> > <Statement number="2" total="10"> > <Property name="BBB"> > <Line pDate="2004-07-08" amount="1.00"/> > <Line pDate="2004-08-22" amount="2.00"/> > <Line pDate="2004-07-19" amount="3.00"/> > <Line pDate="2004-09-10" amount="4.00"/> > </Property> > </Statement> > </Statements> > > My xsl: > > <?xml version="1.0" encoding="iso-8859-1"?> > <xsl:stylesheet version="1.0" > xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> > <xsl:key name="line-date" > match="Statements/Statement/Property/Line" > use="concat(substring(@pDate, 6, 2),'-', > substring(@pDate, 1, 4))" /> > > <xsl:template match="Statements"> > <xsl:apply-templates select='Statement'/> > </xsl:template> > > <xsl:template match="Statement"> > Statement:<xsl:value-of select='@number'/> > <xsl:apply-templates select='Property'/> > > </xsl:template> > > <xsl:template match="Property"> > Name:<xsl:value-of select='@name'/> > <xsl:apply-templates select="Line[generate-id(.) = > generate-id(key('line-date', > concat(substring(@pDate, 6, 2),'-', > substring(@pDate, 1, 4)) )[1]) ]"/> > </xsl:template> > > <xsl:template match="Line"> > <xsl:for-each select="key('line-date', > concat(substring(@pDate, > 6, 2),'-', substring(@pDate, 1, 4)))"> > Date <xsl:value-of select='@pDate'/> amount: > <xsl:value-of > select='format-number(@amount, "#,###,##0.00")'/> > </xsl:for-each> > <!--Month totals.. -->MONTH TOTAL : > <xsl:value-of > select="format-number(sum(key('line-date',concat(substring(@pDate, > 6, > 2),'-', substring(@pDate, 1, > 4)))/@amount),'#,###,##0.00')"/> > </xsl:template> > > </xsl:stylesheet> __________________________________ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] Grouping question, Mukul Gandhi | Thread | [xsl] XSL length output, prenom nom |
Re: [xsl] grouping + global variabl, Wendell Piez | Date | RE: [xsl] using traslate function t, kotes mog |
Month |