ansaurus

Question

How to remove duplicate nodes using XSLT?

Answer 1

+1 A:

Try this:

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"&gt;

  <xsl:template match="/">
    <xsl:apply-templates select="RESPONSE"/>
  </xsl:template>

  <xsl:template match="RESPONSE">
    <RESPONSE>
      <xsl:apply-templates select="RECORD"/>
    </RESPONSE>
  </xsl:template>

  <xsl:template match="RECORD">
    <xsl:variable name="this" select="."/>
    <xsl:variable name="country" select="COUNTRY_ID/text()"/>
    <xsl:if test="not(../RECORD[COUNTRY_ID/text() = $country and generate-id($this) != generate-id(.)])">
      <xsl:copy-of select="."/>
    </xsl:if>
  </xsl:template>

</xsl:stylesheet>

This is all assuming that when you say "duplicate" you mean that COUNTRY_ID has the same content. My XSLT appears to generate your desired output.

Jacob 2009-06-20 23:52:42

thank you thats exactly what i wanted.

2009-06-21 02:09:03

Answer 2

+1 A:

This select will give you the set of when there is a duplicate COUNTRY_ID. (> 1)

select="/RESPONSE/RECORD/COUNTRY_ID/*[count(.|key('x',name())[1])>1]">

Use that set to then exclude those from your select.

I did not run a test, but it should give you the set to work with.

Mark Schultheiss 2009-06-21 00:07:58

Answer 3

A:

take a look here

http://www.exslt.org/set/functions/distinct/index.html

Josh

Josh 2009-06-21 00:22:10

thanks. but thats xslt2.0

2009-06-21 02:09:34

http://www.exslt.org/set/functions/distinct/set.distinct.template.xsl is a xslt 1.0 template implementation

Josh 2009-06-21 06:16:17

ansaurus

tags:

views:

answers:

How to remove duplicate nodes using XSLT?

related questions