[xsl] suppressing duplicate data points contained in xml data

Subject: [xsl] suppressing duplicate data points contained in xml data
From: "David" <dgdunk@xxxxxxxxx>
Date: Tue, 26 Apr 2011 06:45:44 -0400
Hello all.

I have a 3 column table that I want to display data coming from and XML
file.  The data contains duplicates in the first two columns.  Is there a
way to print the data in the columns only when it changes? In other words,
suppress when it's duplicated?

Here is an example of the XML data.

<GROUP  dow="Monday" period="morning" description="Alpha One"/>
<GROUP  dow="Monday" period="morning" description="Alpha Two"/>
<GROUP  dow="Monday" period="morning" description="Alpha Three"/>
<GROUP  dow="Tuesday" period="morning" description="Alpha One"/>
<GROUP  dow="Tuesday" period="morning" description="Alpha Two"/>
<GROUP  dow="Tuesday" period="afternoon" description="Bravo One"/>
<GROUP  dow="Tuesday" period="afternoon" description="Bravo Two"/>
<GROUP  dow="Tuesday" period="afternoon" description="Bravo Three"/>
<GROUP  dow="Tuesday" period="evening" description="Charlie One"/>
<GROUP  dow="Tuesday" period="evening" description="Charlie Two"/>
<GROUP  dow="Tuesday" period="evening" description="Charlie Three"/>
<GROUP  dow="Tuesday" period="night" description="Delta One"/>
<GROUP  dow="Tuesday" period="night" description="Delta Two"/>
<GROUP  dow="Wednesday" period="morning" description="Alpha One"/>
<GROUP  dow="Wednesday" period="morning" description="Alpha Two"/> 

Desired XSL output would be something like: Unfortunately I must stick w/
XSL Version 1.0 as I am running on an AIX FOP engine 

Monday
            Morning
                        Alpha One
                        Alpha Two
                        Alpha Three
Tuesday
            Morning 
                        Alpha One
                        Alpha Two
            Afternoon
                        Bravo One
                        Bravo Two
                        Bravo Three
            Evening
                        Charlie One
                        Charlie Two
                        Charlie Three
            Night
                        Delta One
                        Delta Two
Wednesday
            Morning
                        Alpha One
                        Alpha Two
 
 Any help is appreciated.
 

Thanks, 

David

Current Thread