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
ramesh kumarSubject: Please help....How could I remove the repeated values from the XSL Sheet....
Author: ramesh kumar
Date: 13 Feb 2009 05:44 AM
Originally Posted: 13 Feb 2009 05:36 AM
A part of my xml looks like this:

<A>
<city>xxxx</city>
</A>

<B>
<city>yyyy</city>
</B>

<A>
<city>zzzz/city>
</A>

The desired output should be:

A xxxx
zzzz
B yyyy

That is, A should be print once and associated data should be print under that( A is repeating 2 times).
Can this be done?


Please Help..


Regards,
Ramesh

Posttop
John BamptonSubject: Please help....How could I remove the repeated values from the XSL Sheet....
Author: John Bampton
Date: 13 Feb 2009 08:19 AM
Hi, this is the XML that I used

<?xml version="1.0" encoding="UTF-8"?>
<root>

<A>
<city>xxxx</city>
</A>

<B>
<city>yyyy</city>

</B>

<A>
<city>zzzz</city>

</A>



</root>


And here is the XSL that I wrote

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0">
<xsl:template match="/">
<xsl:for-each-group group-by="name()" select="/child::root/*">
<xsl:variable name="currentitem" select="./name()"></xsl:variable>
<xsl:value-of select="./name()"></xsl:value-of>
<xsl:for-each select="/child::root/*">
<xsl:if test="$currentitem = ./name()">
<xsl:value-of select="city"></xsl:value-of>
</xsl:if>
</xsl:for-each>
</xsl:for-each-group>
</xsl:template>
</xsl:stylesheet>

Cheers, John Bampton.

 
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.