Cart
|
[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: Multi level Grouping using xslt1.0
 I am trying to transform a sample input xml given below using xslt 1.0 (I cannot move on to XSLT 2.0 as .NET does not support it and I cannot use other xslt processors)- I find the variable-based approach to multi-level grouping is very easy to understand, and it avoids any statistically-possible collisions when creating keys based on concatenation. The requirement is to group by Company, then by Business, then by Department & finally the Account. I hope the example below helps, as it reproduces your desired output precisely. I am using the following xslt - In your example you are using keys which have document-wide scope, yet you are trying to group with less-than-document-wide scope. Using variables it is easy to work on only portions of your document. In my example below I am looking at each subset of the tree in a variable and acting only at the first member in that variable for each unique value in that subset. . . . . . . . . . . Ken T:\ftemp>type bafna.xml
<Data>
<Rows>
<Row>
<Company>491</Company>
<Business>0000</Business>
<Department>0000</Department>
<Account>30010</Account>
</Row>
<Row>
<Company>491</Company>
<Business>0000</Business>
<Department>0001</Department>
<Account>30010</Account>
</Row>
<Row>
<Company>498</Company>
<Business>0000</Business>
<Department>0000</Department>
<Account>30010</Account>
</Row>
<Row>
<Company>498</Company>
<Business>0001</Business>
<Department>0000</Department>
<Account>30011</Account>
</Row>
</Rows>
</Data>T:\ftemp>call xslt bafna.xml bafna.xsl bafna.out T:\ftemp>type bafna.out
<?xml version="1.0" encoding="utf-8"?>
<Message>
<Company>
<Code>491</Code>
<Business>
<Code>0000</Code>
<Department>
<Code>0000</Code>
<Account>30010</Account>
</Department>
<Department>
<Code>0001</Code>
<Account>30010</Account>
</Department>
</Business>
</Company>
<Company>
<Code>498</Code>
<Business>
<Code>0000</Code>
<Department>
<Code>0000</Code>
<Account>30010</Account>
</Department>
</Business>
<Business>
<Code>0001</Code>
<Department>
<Code>0000</Code>
<Account>30011</Account>
</Department>
</Business>
</Company>
</Message>
T:\ftemp>type bafna.xsl
<?xml version="1.0" encoding="US-ASCII"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
version="1.0"><xsl:output indent="yes"/> <xsl:template match="/">
<xsl:variable name="rows" select="Data/Rows/Row"/>
<Message>
<xsl:for-each select="$rows">
<xsl:if test="generate-id(.)=
generate-id($rows[Company=current()/Company][1])">
<xsl:variable name="company"
select="$rows[Company=current()/Company]"/>
<Company>
<Code><xsl:value-of select="Company"/></Code>
<xsl:for-each select="$company">
<xsl:if test="generate-id(.)=
generate-id($company[Business=current()/Business][1])">
<xsl:variable name="business"
select="$company[Business=current()/Business]"/>
<Business>
<Code><xsl:value-of select="Business"/></Code>
<xsl:for-each select="$business">
<xsl:if test="generate-id(.)=
generate-id($business
[Department=current()/Department][1])"> <xsl:variable name="department"
select="$business
[Department=current()/Department]"/>
<Department>
<Code><xsl:value-of select="Department"/></Code>
<xsl:copy-of select="$department/Account"/>
</Department>
</xsl:if>
</xsl:for-each>
</Business>
</xsl:if>
</xsl:for-each>
</Company>
</xsl:if>
</xsl:for-each>
</Message>
</xsl:template></xsl:stylesheet> T:\ftemp>rem Done! -- XQuery/XSLT training in Prague, CZ 2009-03 http://www.xmlprague.cz Training tools: Comprehensive interactive XSLT/XPath 1.0/2.0 video Video lesson: http://www.youtube.com/watch?v=PrNjJCh7Ppg&fmt=18 Video overview: http://www.youtube.com/watch?v=VTiodiij6gE&fmt=18 G. Ken Holman mailto:gkholman@xxxxxxxxxxxxxxxxxxxx Crane Softwrights Ltd. http://www.CraneSoftwrights.com/s/ Male Cancer Awareness Nov'07 http://www.CraneSoftwrights.com/s/bc Legal business disclaimers: http://www.CraneSoftwrights.com/legal 
|
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
|
