XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Aleem SheikhSubject: Unique nodes based on two attributes
Author: Aleem Sheikh
Date: 01 Aug 2009 07:55 AM
Hi All,
I have been trying with this issue for a couple of days now, I will appreciate any help.

Following is the xml and I need unique rows based on two attribute i.e "Organization" and "Event". I have been trying to constract an IF condition which tells me whether the current node is a duplicate based on above mentioned attributes under a loop.

<?xml version="1.0" encoding="UTF-8"?>
<Rows>
<Row Title="Paul Smith" Role="Finance Director" Organization="London Trust" Organization_x0020_Type="Trust" Description=" " Event="Communication Procedures" >
</Row>
<Row Title="John Martin" Role="" Organization="Oxford Deanery" Organization_x0020_Type="Deanery" Description=" " Event="Communication Procedures" >
</Row>
<Row Title="Abdul Waheed" Role="" Organization="Oxford Deanery" Organization_x0020_Type="Deanery" Description=" " Event="Communication Procedures" >
</Row>
<Row Title="Jojo" Role="IT Head" Organization="Oxford Deanery" Organization_x0020_Type="Deanery" Description=" " Event="Joint IT infrastructure" >
</Row>
<Row Title="Joe Black" Role="" Organization="London Trust" Organization_x0020_Type="Trust" Description="" Event="Data sharing standards" >
</Row>
<Row Title="Peter Crouch" Role="" Organization="Oxford Deanery" Organization_x0020_Type="Deanery" Description="" Event="Data sharing standards" >
</Row>
<Row Title="Steven King" Role="" Organization="Northern Deanery" Organization_x0020_Type="Deanery" Description="" Event="Data sharing standards" >
</Row>
<Row Title="David Osborne" Role="" Organization="Oxford Deanery" Organization_x0020_Type="Deanery" Description="" Event="Hardware for data sharing" >
</Row>
<Row Title="David Brooks" Role="" Organization="Northern Deanery" Organization_x0020_Type="Deanery" Description="" Event="Hardware for data sharing" >
</Row>
</Rows>

Postnext
Alberto MassariSubject: Unique nodes based on two attributes
Author: Alberto Massari
Date: 11 Aug 2009 08:04 AM
Hi Aleem,
you can use grouping to obtain the list of unique rows: have a look at http://www.jenitennison.com/xslt/grouping/index.html for some techniques.

Alberto

Posttop
Aleem SheikhSubject: Unique nodes based on two attributes
Author: Aleem Sheikh
Date: 11 Aug 2009 09:36 AM
Thanks Alberto,
It's a good resource, it's a shame that I have worked with Jeni in the past, but never checked her website in detail.

 
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.