OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help



   Xml to HTML using XSL kinda tricky

[ Lists Home | Date Index | Thread Index ]

Hi All

I have an Xml file like the following.


What I am tryin to do is:

1. Group all the CustomerID's
present in the XML file and display a column of Unique

I have a criteria table for the products like the

1000,1001,1005,1100 -- Groceries
2000,2001,2005,2300 -- Food
3000,3004,6000,5000 -- Books

(I wouldnt mind having this as an Xml)

2. Then take all the Product ID's(
/CustomerList/Customer/Product/ProductID), for each of
the CustomerID that is grouped above, map against the
above Criteria table and find the count of each of the
product categories that a particular CustomerID has

The resulting table should be like the following

CustomerID   Groceries   Food    Books    Total
NNNWWW          2          0      1         3
NNNPPP          0          3      2         5
NNNYYY          2          2      2         6

Summary Total   4          5      5         15

Any help in how to go about will be greatly


Do you Yahoo!?
HotJobs - Search new jobs daily now


News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS