This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
Re: Grouping Data Problem
- From: Joerg Heinicke <joerg dot heinicke at gmx dot de>
- To: xsl-list at lists dot mulberrytech dot com
- Date: Sat, 01 Jun 2002 02:39:11 +0200
- Subject: Re: [xsl] Grouping Data Problem
- References: <0E7280F9F5CFD411B9F7009027289D000712654B@mercury.boat.com>
- Reply-to: xsl-list at lists dot mulberrytech dot com
Hello Jeff,
it's difficult to understand, what you really want. Is it a grouping
problem or only a summing problem. From your "what I am trying to do" I
assume the last. But you always have the error_count per site per day.
Maybe it's still a grouping problem. Hmm? I think it's easier, when you
sent the expected output from the below XML or explained it in another way.
Joerg
Jeff Killingsworth wrote:
> I have multiple web site and have built a way to log all errors on these
> sites in to files for later reference. I have also built a way to parse
> each file to get me the number of errors from each file per site. All of the
> data is returned in the form of xml (see below).
> My trouble is in the grouping mainly because of the multiple files that can
> represent one file.
>
> Here is what I am trying to do:
> 1) Loop through each site
> 2) Get a distinct error count per day for each site.
>
> I have tried using an xsl:key but can not get it to work.
>
> Please help.
>
>
> [ XML ]
> ----------------------------------------------------------------------------
> <?xml version="1.0" encoding="utf-8"?>
> <data>
> <site name="www.111.COM">
> <file date="5/25/2002" error_count="28">e:\2002_05_25.csv</file>
> <file date="5/26/2002" error_count="28">e:\2002_05_26.csv</file>
> <file date="5/27/2002" error_count="288">e:\2002_05_27.csv</file>
> <file date="5/28/2002" error_count="516">e:\2002_05_28.csv</file>
>
> <file date="5/29/2002" error_count="22">e:\2002_05_29.csv</file>
> <file date="4/29/2002" error_count="41">e:\old\2002_04_29.csv</file>
>
> <file date="4/30/2002" error_count="2">e:\old\2002_04_30.csv</file>
> <file date="5/1/2002" error_count="3">e:\old\2002_05_01.csv</file>
> <file date="5/2/2002" error_count="8">e:\old\2002_05_02.csv</file>
> <file date="5/3/2002" error_count="6">e:\old\2002_05_03.csv</file>
> <file date="5/4/2002" error_count="1">e:\old\2002_05_04.csv</file>
> <file date="5/5/2002" error_count="1">e:\old\2002_05_05.csv</file>
> <file date="5/6/2002" error_count="12">e:\old\2002_05_06.csv</file>
> <file date="5/7/2002" error_count="78">e:\old\2002_05_07.csv</file>
> <file date="5/7/2002" error_count="6">e:\old\2002_05_07.csv.1</file>
> <file date="5/8/2002" error_count="1">e:\old\2002_05_08.csv</file>
> <file date="5/9/2002" error_count="24">e:\old\2002_05_09.csv</file>
> <file date="5/10/2002" error_count="3">e:\old\2002_05_10.csv</file>
> <file date="5/11/2002" error_count="8">e:\old\2002_05_11.csv</file>
> <file date="5/12/2002" error_count="4">e:\old\2002_05_12.csv</file>
> <file date="5/15/2002" error_count="9">e:\old\2002_05_15.csv</file>
> <file date="5/17/2002" error_count="2">e:\old\2002_05_17.csv</file>
> <file date="5/18/2002" error_count="9">e:\old\2002_05_18.csv</file>
> <file date="5/19/2002" error_count="5">e:\old\2002_05_19.csv</file>
> <file date="5/22/2002" error_count="79">e:\old\2002_05_22.csv</file>
> <file date="5/23/2002" error_count="64">e:\old\2002_05_23.csv</file>
> <file date="5/24/2002" error_count="46">e:\old\2002_05_24.csv</file>
> </site>
> <site name="www.222.ORG">
> <file date="5/24/2002" error_count="7">E:\2002_05_24.csv</file>
> <file date="5/25/2002" error_count="7">E:\2002_05_25.csv</file>
> <file date="5/26/2002" error_count="17">E:\2002_05_26.csv</file>
> <file date="5/27/2002" error_count="19">E:\2002_05_27.csv</file>
> <file date="5/28/2002" error_count="16">E:\2002_05_28.csv</file>
> <file date="5/29/2002" error_count="13">E:\2002_05_29.csv</file>
> </site>
> <site name="www.333.ORG">
> <file date="5/24/2002" error_count="79">E:\2002_05_24.csv</file>
> <file date="5/25/2002" error_count="42">E:\2002_05_25.csv</file>
> <file date="5/26/2002" error_count="22">E:\2002_05_26.csv</file>
> <file date="5/27/2002" error_count="33">E:\2002_05_27.csv</file>
> <file date="5/28/2002" error_count="19">E:\2002_05_28.csv</file>
> <file date="5/29/2002" error_count="9">E:\2002_05_29.csv</file>
> </site>
> </data>
>
> Thanks,
> ______________________
> Jeff Killingsworth
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list