How do I de-duplicate a list of nodes in XSLT - and return the last node encountered?

Posted by Broam on Stack Overflow See other posts from Stack Overflow or by Broam
Published on 2010-04-28T18:58:15Z Indexed on 2010/04/29 16:27 UTC
Read the original article Hit count: 348

Filed under:

xslt-2.0

I've seen lots of "de-duplicate this xml" questions but everyone wants the first node or the nodes are identical. I have a bit of a bigger puzzle.

I have a list of articles in XML, a relevant snippet is shown:

<item><key>Article1</key><stamp>100</stamp></item>
<item><key>Article1</key><stamp>130</stamp></item>
<item><key>Article2</key><stamp>800</stamp></item>
<item><key>Article1</key><stamp>180</stamp></item>
<item><key>Article3</key><stamp>900</stamp></item>
<item><key>Article3</key><stamp>950</stamp></item>
<item><key>Article4</key><stamp>990</stamp></item>
<item><key>Article5</key><stamp>999</stamp></item>

I'd like a list of nodes where the keys are unique and where the last instance is returned, not the first: Stamp (integer) is always increasing for elements of a particular key. Ideally I'd like "largest stamp" but they're always in order so the shortcut is ok.

Desired result: (Order doesn't really matter.)

<item><key>Article2</key><stamp>800</stamp></item>
<item><key>Article1</key><stamp>180</stamp></item>
<item><key>Article3</key><stamp>950</stamp></item>
<item><key>Article4</key><stamp>990</stamp></item>
<item><key>Article5</key><stamp>999</stamp></item>

I'm somewhat confused on how to get this list. Any ideas?

I'm using the Saxon processor if it matters.

Related posts about xslt-2.0

Why do XSLT editors insert tab or space characters into XSLT to format it?

as seen on Programmers - Search for 'Programmers'
All XSLT editors I've tried till now add tab or space characters to the XSLT to indent it for formatting. This is done even in places within the XSLT where these characters are significant to the XSLT processor. XSLT modified for formatting in this way can produce output very different to that of… >>> More
How to replace text defined in a given tag or element using xslt, xslt string replace

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, Please help me with this xslt transformation. Source Xml <xml> <test>This is a <bold>sample</bold> description. Please help me with a sample</text> </xml> Expected Output: This is a sample description. Please help me with a sample I just need to make… >>> More
C# and XSLT (using document() function in XSLT generates error)

as seen on Stack Overflow - Search for 'Stack Overflow'
I'd like to use embedded resources in my XSLT file, but while invoking 'document(...)' C# complains that "Error during loading document ..." I'd like to use defined resources in XSLT file and get them by this: "document('')//my:resources/"... How can i do that?? ex xsl: <?xml version="1.0"… >>> More
Turning XSLT into a simple HTML snippet.

as seen on Stack Overflow - Search for 'Stack Overflow'
http://drp.ly/yeAex <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/data/tour/entry"> <img src="{filename}"/> <h2>{heading}</h2> {description} </xsl:template> </xsl:stylesheet> Here… >>> More
JQuery > XSLT Plugin > Component returned failure code: 0x80600011 [nsIXSLTProcessorObsolete.transfo

as seen on Stack Overflow - Search for 'Stack Overflow'
So, I'm using the XSLT plugin for JQuery, and here's my code: function AddPlotcardEventHandlers(){ // some code } function reportError(exception){ alert(exception.constructor.name + " Exception: " + ((exception.name) ? exception.name : "[unknown name]") + " - " + exception.message); } function… >>> More

Developer IT