SSDN - Please help to create a XSL to remove the duplicates from this xml file

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

ramesh kumar

Subject: Please help to create a XSL to remove the duplicates from this xml file
Author: ramesh kumar
Date: 12 Feb 2009 07:31 AM
Originally Posted: 12 Feb 2009 07:11 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.
Can this be done?

Please Help..

Regards,
Ramesh

>

John Bampton

Subject: Please help to create a XSL to remove the duplicates from this xml file
Author: John Bampton
Date: 13 Feb 2009 08:21 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 10 11 12 13 14 15 16 17 18 19 20

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 to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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.