Subject: [xsl] Grouping and numbering in XSLT 2.0, From: <geirr.prestholdt@xxxxxxxxxxxxx> Date: Fri, 11 Nov 2005 15:16:34 +0100 |
I have an XML report like the one below. I want to group vendor-data by vendor. I have no number to use as grouping key, but as you can understand each vendor has one name, one cage etc. The result I want is listed at the end. If I could assign a sequential number to each <value> within each <cell>, and then use this number as grouping key, I believe the problem can be solved. I cant just figure out how to this in one XSLT style sheet. Source list: <?xml version="1.0" encoding="UTF-8"?> <vendors> <cell name="Company"> <value>AMPHENOL AEROSPACE OPERATIONS</value> <value>ITT CANNON</value> <value>SOURIAU CONNECTION TECHNOLOGY (FCI)</value> <value>DEUTSCH ECD</value> <value>AERO ELECTRIC CONNECTOR INC</value> <value>AMPHENOL CORPORATION</value> <value>TEC ELECTRICAL COMPONENTS LTD</value> </cell> <cell name="Cage"> <value>77820</value> <value>71468</value> <value>F0225</value> <value>11139</value> <value>59976</value> <value>74868</value> <value>K0690</value> </cell> <cell name="Address"> <value/> <value/> <value/> <value/> <value>TORRANCE</value> <value/> <value/> </cell> </vendors> Preferred result: <?xml version="1.0" encoding="UTF-8"?> <Vendors> <vendor> <cell name="Company"> <value>AMPHENOL AEROSPACE OPERATIONS</value> </cell> <cell name="Cage"> <value>77820</value> </cell> <cell name="Address"> <value/> </cell> </vendor> <vendor> <cell name="Company"> <value>ITT CANNON</value> </cell> <cell name="Cage"> <value>71468</value> </cell> <cell name="Address"> <value/> </cell> </vendor> <vendor> <cell name="Company"> <value>SOURIAU CONNECTION TECHNOLOGY (FCI)</value> </cell> <cell name="Cage"> <value>F0225</value> </cell> <cell name="Address"> <value/> </cell> </vendor> <vendor> <cell name="Company"> <value>DEUTSCH ECD</value> </cell> <cell name="Cage"> <value>11139</value> </cell> <cell name="Address"> <value/> </cell> </vendor> <vendor> <cell name="Company"> <value>AERO ELECTRIC CONNECTOR INC</value> </cell> <cell name="Cage"> <value>59976</value> </cell> <cell name="Address"> <value>TORRANCE</value> </cell> </vendor> <vendor> <cell name="Company"> <value>AMPHENOL CORPORATION</value> </cell> <cell name="Cage"> <value>74868</value> </cell> <cell name="Address"> <value/> </cell> </vendor> <vendor> <cell name="Company"> <value>TEC ELECTRICAL COMPONENTS LTD</value> </cell> <cell name="Cage"> <value>K0690</value> </cell> <cell name="Address"> <value/> </cell> </vendor> </Vendors> Regards Geirr
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: [xsl] Filtering problem, Haarman, Michael | Thread | RE: [xsl] Grouping and numbering in, Haarman, Michael |
[xsl] Filtering problem, Ryan Puddephatt | Date | Re: [xsl] xquery to xslt update, David Carlisle |
Month |