[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

RE: Assistance with hiding duplicate data

Subject: RE: Assistance with hiding duplicate data
From: "Michael Kay" <mike@xxxxxxxxxxxx>
Date: Thu, 4 Sep 2008 21:26:26 +0100
RE:  Assistance with hiding duplicate data
The problem is known as "grouping", and if you google for "XSLT grouping"
(or search the archives of this list at www.markmail.org, or look in the
index of your favourite XSLT textbook) you will find a copious literature on
the subject. It's easiest in XSLT 2.0 using the xsl:for-each-group
instruction.

Michael Kay
http://www.saxonica.com/ 

> -----Original Message-----
> From: Garrett Murphy [mailto:gmurphy@xxxxxxxxxxxx] 
> Sent: 04 September 2008 20:53
> To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> Subject:  Assistance with hiding duplicate data
> 
> I've combed these boards over and can't find anything that 
> particularly helps with this exact issue.
>  
> Data:
> <report>
>    <record>
>        <Beneficiary_Name>Canada, Peter</Beneficiary_Name>
>        <Case_No>0606-0000000055</Case_No>
>        <Current_Status>-</Current_Status>
>        <Current_Status_Expires></Current_Status_Expires>
>        <Birth_Date>05/27/1971</Birth_Date>
>        <Case_Opened>06/14/2006</Case_Opened>
>        <Responsible_Attorney>NR</Responsible_Attorney>
>    </record>
>    <record>
>        <Beneficiary_Name>Mexico, Ron</Beneficiary_Name>
>        <Case_No>0608-0000000275</Case_No>
>        <Current_Status>H-1B</Current_Status>
>        <Current_Status_Expires>00/00/00</Current_Status_Expires>
>        <Birth_Date>May 26, 19</Birth_Date>
>        <Case_Opened>08/23/2006</Case_Opened>
>        <Responsible_Attorney>HI</Responsible_Attorney>
>    </record>
>    <record>
>        <Beneficiary_Name>Canada, Peter</Beneficiary_Name>
>        <Case_No>0606-0000000055</Case_No>
>        <Current_Status>-</Current_Status>
>        <Current_Status_Expires>xxxxxxxxxx</Current_Status_Expires>
>        <Birth_Date>05/27/1971</Birth_Date>
>        <Case_Opened>09/05/2006</Case_Opened>
>        <Responsible_Attorney>HI</Responsible_Attorney>
>    </record>
>    <record>
>        <Beneficiary_Name>Mexico, Ron</Beneficiary_Name>
>        <Case_No>0608-0000000275</Case_No>
>        <Current_Status>H-1B</Current_Status>
>        <Current_Status_Expires>00/00/00</Current_Status_Expires>
>        <Birth_Date>May 26, 19</Birth_Date>
>        <Case_Opened>09/18/2006</Case_Opened>
>        <Responsible_Attorney>HI</Responsible_Attorney>
>    </record>
>    <record>
>        <Beneficiary_Name>Mexico, Ron</Beneficiary_Name>
>        <Case_No>0608-0000000275</Case_No>
>        <Current_Status>H-1B</Current_Status>
>        <Current_Status_Expires>00/00/00</Current_Status_Expires>
>        <Birth_Date>May 26, 19</Birth_Date>
>        <Case_Opened>09/21/2006</Case_Opened>
>        <Responsible_Attorney>HI</Responsible_Attorney>
>    </record>
>    <record>
>        <Beneficiary_Name>Canada, Peter</Beneficiary_Name>
>        <Case_No>0606-0000000055</Case_No>
>        <Current_Status>-</Current_Status>
>        <Current_Status_Expires>xxxxxxxxxx</Current_Status_Expires>
>        <Birth_Date>05/27/1971</Birth_Date>
>        <Case_Opened>09/18/2006</Case_Opened>
>        <Responsible_Attorney>[R]TADC</Responsible_Attorney>
>    </record>
>    <record>
>        <Beneficiary_Name>Canada, Peter</Beneficiary_Name>
>        <Case_No>0606-0000000055</Case_No>
>        <Current_Status>-</Current_Status>
>        <Current_Status_Expires>xxxxxxxxxx</Current_Status_Expires>
>        <Birth_Date>05/27/1971</Birth_Date>
>        <Case_Opened>09/18/2006</Case_Opened>
>        <Responsible_Attorney>NR</Responsible_Attorney>
>    </record>
> </report>
> 
> At my work, we generate reports from a system that generates 
> XML and we then use the XSL to format the reports.  Users are 
> able to choose the columns they wish.
> I'm trying to arrange it so that the data is generated in a 
> table sorted by the Beneficiary_Name, and without any 
> duplicated data for the beneficiary.  So, in the case of 
> Peter Canada, the first record of his that shows would have 
> all the fields filled in, but each record after that would 
> only have Case_Opened and Responsible_Attorney, as those are 
> the only ones changing.
>  
> I've tried several different techniques, but I'm having no 
> luck at all.
> Any suggestions?
>  
>  
> 
> Garrett Murphy
> gmurphy@xxxxxxxxxxxx

Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.