Best way to group data (in XML)

[jehugaleahsa]

Hello:

I have an XML file that contains records with a Date attribute. I
would like to group all the records together with a particular date,
so that I can later iterate over the different dates to calculate
information based on the contained records.

So, for instance, I have sales records for every day in the year, I
would like to calculate the total sales for each week in the year. So
I need to be able to group by weeks. Is there a tool for XML that will
allow me to group like this?

Thanks,
Travis

 

[Martin Honnen]

I have an XML file that contains records with a Date attribute. I
would like to group all the records together with a particular date,
so that I can later iterate over the different dates to calculate
information based on the contained records.

So, for instance, I have sales records for every day in the year, I
would like to calculate the total sales for each week in the year. So
I need to be able to group by weeks. Is there a tool for XML that will
allow me to group like this?

XSLT 2.0 or XQuery are languages to perform the grouping. Saxon 9 from
<http://saxon.sourceforge.net/> implements both XSLT 2.0 and XQuery and
has a .NET version.
Grouping can also be done with XSLT 1.0 where the .NET framework has an
implementation with System.Xml.Xsl.XslCompiledTransform.

 

[jehugaleahsa]

XSLT 2.0 or XQuery are languages to perform the grouping. Saxon 9 from
<http://saxon.sourceforge.net/> implements both XSLT 2.0 and XQuery and
has a .NET version.
Grouping can also be done with XSLT 1.0 where the .NET framework has an
implementation with System.Xml.Xsl.XslCompiledTransform.

Thanks. I have an implementation using the xsl:key element with XSLT.
I will stick with that. I think I will look at XQuery while I'm at it.

Thanks again,
Travis

 

[Jon Skeet [C# MVP]]

I have an XML file that contains records with a Date attribute. I
would like to group all the records together with a particular date,
so that I can later iterate over the different dates to calculate
information based on the contained records.

So, for instance, I have sales records for every day in the year, I
would like to calculate the total sales for each week in the year. So
I need to be able to group by weeks. Is there a tool for XML that will
allow me to group like this?

Do you mean you want to group the records in the original XML file, or
you want to process an XML file which has ungrouped data and group the
data in memory?

If it's the latter, and if .NET 3.5 is an option, I suggest you look at
LINQ to XML. It's nice and powerful

 

[jehugaleahsa]

Do you mean you want to group the records in the original XML file, or
you want to process an XML file which has ungrouped data and group the
data in memory?

If it's the latter, and if .NET 3.5 is an option, I suggest you look at
LINQ to XML. It's nice and powerful

I have looked at it. It is pretty spiffy. Unfortunately we are in a
transition period. Hopefully soon!

 

[Jon Skeet [C# MVP]]

I have looked at it. It is pretty spiffy. Unfortunately we are in a
transition period. Hopefully soon!

I suspect there are more than a few of us in exactly that situation

Fortunately I get to use .NET 3.5 for my book's web site, so I do get
to do more than "toy" projects in it - although the web site is tiny
anyway, really.

 

[Cor Ligthert[MVP]]

Why not translate it to XSD using the tool for that.

And then generate a stronly typed dataset class for it.

Load in the instanced version of that your XML

You can iterate in that in almost every way you want.

Cor

 

[Marc Gravell]

The classic answer for such in xslt would be "Muenchian Grouping";
since you are using xsl:key, I suspect you are more than half-way
there anyway ;-p

Just search for the above term; very easy to use, and very quick. Of
course, it'll help if your week-number is already in the data,
otherwise you might need a method to do that first...

Marc