two level grouping problem

Play the video

Subject: two level grouping problem
From: Terry Ofner <tofner@xxxxxxxxxxx>
Date: Thu, 25 Oct 2007 16:19:35 -0400

I am trying to group down to two levels. Here is a sample of the original xml (blank lines added for clarity):

<state> <standard><g_code>G4U1S01</g_code> <state-objective state="AL">R.3.6. Blah blah blah</state-objective></ standard>

<standard><g_code>G4U1S01</g_code> <state-objective state="AK">[4] 2.1.4. Blah blah blah</state- objective></standard>

<standard><g_code>G4U1S01</g_code> <state-objective state="AK">[4] 2.1.2. Blah blah blah</state- objective></standard>

<standard><g_code>G4U1S01</g_code> <state-objective state="AK">[4] 2.1.1. Blah blah blah</state- objective></standard>

<standard><g_code>G4U1S02</g_code> <state-objective state="AL">R.3.7. Blah blah blah</state-objective></ standard> . . . . </state>

Here is what I am looking for. Notice that the g_codes have been grouped and the AK objectives have been groups together separated by a pipe character.

<standard> <g_code>G4U1S01</g_code> <state-objective state="AL">R.3.6. Blah blah blah </state-objective> <state-objective state="AK">[4] 2.1.4. Blah blah blah | [4] 2.1.2. Blah blah blah | [4] 2.1.1. Blah blah blah</state-objective> </standard>

My current XSLT:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/ Transform"> <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>

<xsl:key name="gcode_key" match="standard" use="g_code"/> <xsl:key name="state_by_gcode" match="standard" use="concat(., '+', / standard/state-objective/@state)" />

<xsl:template match="/"> <xsl:for-each select="/state/standard[generate-id(.)=generate-id(key ('gcode_key' , g_code))]/g_code"> <xsl:sort/>

<xsl:text>
</xsl:text><standard><g_code><xsl:value-of select="."/ ></g_code><xsl:text>
</xsl:text>

<xsl:for-each select="key('gcode_key', .) [generate-id() = generate-id(key('state_by_gcode', concat(., '+', @state))[1])]"> <xsl:sort select="@state"/> <xsl:copy-of select="state-objective" /><xsl:text>
</ xsl:text> </xsl:for-each> </standard> </xsl:for-each> </xsl:template>

</xsl:stylesheet>

It produces the following output:

<standard><g_code>G4U1S01</g_code> <state-objective state="AL">R.3.6. Blah blah blah</state-objective> <state-objective state="AK">[4] 2.1.4.Blah blah blah</state-objective> <state-objective state="AK">[4] 2.1.2. Blah blah blah</state-objective> <state-objective state="AK">[4] 2.1.1. Blah blah blah</state-objective> <state-objective state="AZ">R04-S1C4-02. Blah blah blah</state- objective> . . . </standard>

Apparently my first group key is working. I am not sure what the second one is doing, if anything. Can anyone show me where I am going wrong?

Thanks in advance.

Terry Ofner

Current Thread
RE: Re: XSL to ODF/OOXML, (continued) Michael Kay - 25 Oct 2007 21:54:28 -0000 David Carlisle - 25 Oct 2007 22:38:27 -0000 Steve - 25 Oct 2007 20:24:37 -0000 David Carlisle - 25 Oct 2007 22:37:26 -0000 Terry Ofner - 25 Oct 2007 20:20:07 -0000 <= G. Ken Holman - 25 Oct 2007 21:42:36 -0000

<- Previous	Index	Next ->
Re: Re: XSL to ODF/OOXML, David Carlisle	Thread	Re: two level grouping proble, G. Ken Holman
RE: Re: XSL to ODF/OOXML, Scott Trenda	Date	Re: Re: XSL to ODF/OOXML, Steve
	Month

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

RSS 2.0
Atom 0.3

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >