Cart
|
[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] XSLT - Multiple Level Grouping with Unknown Level
 I have just started doing coding in XSLT and stuck with a unique problem. I have done the coding for grouping with fixed levels but finiding the solution for this one is getting too complicated. I have looked for the solution at various places but couldn't find one. Finaly I decided to post my query to you. Please note that I am restricted to use XSLT version 1.0 and I have to produce the result in a table. Also the levels of grouping is not fixed. It can be grouped further on Part. My XML document (partial) is as follows :- <Group>
<GroupValue>SUPP1</GroupValue>
<Group>
<GroupValue>PO001</GroupValue>
<Row>
<ColumnValue>1</ColumnValue>
<ColumnValue>PART1</ColumnValue>
<ColumnValue>1.00</ColumnValue>
<ColumnValue>1.00</ColumnValue>
</Row>
<Row>
<ColumnValue>2</ColumnValue>
<ColumnValue>PART2</ColumnValue>
<ColumnValue>2.00</ColumnValue>
<ColumnValue>2.00</ColumnValue>
</Row>
<Row>
<ColumnValue>3</ColumnValue>
<ColumnValue>PART1</ColumnValue>
<ColumnValue>3.00</ColumnValue>
<ColumnValue>3.00</ColumnValue>
</Row>
</Group>
<Group>
<GroupValue>PO002</GroupValue>
<Row>
<ColumnValue>1</ColumnValue>
<ColumnValue>PART1</ColumnValue>
<ColumnValue>1.00</ColumnValue>
<ColumnValue>1.0000</ColumnValue>
</Row>
<Row>
<ColumnValue>2</ColumnValue>
<ColumnValue>PART2</ColumnValue>
<ColumnValue>2.00</ColumnValue>
<ColumnValue>2.0000</ColumnValue>
</Row>
<Row>
<ColumnValue>3</ColumnValue>
<ColumnValue>PART1</ColumnValue>
<ColumnValue>3.00</ColumnValue>
<ColumnValue>3.00</ColumnValue>
</Row>
</Group>
</Group><Group>
<GroupValue>SUPP2</GroupValue>
<Group>
<GroupValue>PO003</GroupValue>
<Row>
<ColumnValue>1</ColumnValue>
<ColumnValue>PART1</ColumnValue>
<ColumnValue>11.00</ColumnValue>
<ColumnValue>11.00</ColumnValue>
</Row>
<Row>
<ColumnValue>2</ColumnValue>
<ColumnValue>PART2</ColumnValue>
<ColumnValue>22.00</ColumnValue>
<ColumnValue>22.00</ColumnValue>
</Row>
<Row>
<ColumnValue>3</ColumnValue>
<ColumnValue>PART1</ColumnValue>
<ColumnValue>33.00</ColumnValue>
<ColumnValue>33.00</ColumnValue>
</Row>
</Group>
<Group>
<GroupValue>PO004</GroupValue>
<Row>
<ColumnValue>1</ColumnValue>
<ColumnValue>PART1</ColumnValue>
<ColumnValue>11.00</ColumnValue>
<ColumnValue>11.00</ColumnValue>
</Row>
<Row>
<ColumnValue>2</ColumnValue>
<ColumnValue>PART2</ColumnValue>
<ColumnValue>22.00</ColumnValue>
<ColumnValue>22.00</ColumnValue>
</Row>
<Row>
<ColumnValue>3</ColumnValue>
<ColumnValue>PART1</ColumnValue>
<ColumnValue>33.00</ColumnValue>
<ColumnValue>33.00</ColumnValue>
</Row>
</Group>
</Group>And the output should be as follows :- Supplier PO Number Line Part Number Qty Reqd Net Value Supp1 PO001 1 Part1 1.00 1.00 2 Part2 2.00 2.00 3 Part1 3.00 3.00 PO002 1 Part1 1.00 1.00 2 Part2 2.00 2.00 3 Part1 3.00 3.00 Supp2 PO003 1 Part1 11.00 11.00 2 Part2 22.00 22.00 3 Part1 33.00 33.00 PO004 1 Part1 11.00 11.00 2 Part2 22.00 22.00 3 Part1 33.00 33.00 Thanking you in advance. Arun _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ 
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! 
Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|
