Summary This snippet shows how given a set of name/value pairs for a record from a set of records, to "reconstitute" the whole records.

Additional information

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" > <xsl:output method="text"/> <xsl:variable name="Root" select="/"/> <!-- Obtain all different "name"s --> <xsl:variable name="sortedNames"> <xsl:for-each select="/root/data/item"> <xsl:sort select="@name"/> <xsl:element name="name"> <xsl:value-of select="@name"/> </xsl:element> </xsl:for-each> </xsl:variable> <xsl:variable name="uniqueNames"> <xsl:for-each select="msxsl:node-set($sortedNames)/name[position()=1 or . != preceding-sibling::name[1~~"> <xsl:element name="name"> <xsl:value-of select="."/> </xsl:element> </xsl:for-each> </xsl:variable> <!-- Obtain all different "id"s --> <xsl:variable name="sortedIds"> <xsl:for-each select="/root/data/item"> <xsl:sort select="@id"/> <xsl:element name="id"> <xsl:value-of select="@id"/> </xsl:element> </xsl:for-each> </xsl:variable> <xsl:variable name="uniqueIds"> <xsl:for-each select="msxsl:node-set($sortedIds)/id[position()=1 or . != preceding-sibling::id[1~~"> <xsl:element name="id"> <xsl:value-of select="."/> </xsl:element> </xsl:for-each> </xsl:variable> <xsl:template match="/"> <!-- Output the "title" line --> <xsl:text>id,</xsl:text> <xsl:for-each select="msxsl:node-set($uniqueNames)/*"> <xsl:value-of select="."/> <xsl:if test="position() != last()"> <xsl:text>,</xsl:text> </xsl:if> </xsl:for-each> <!-- Output every "data" line --> <xsl:for-each select="msxsl:node-set($uniqueIds)/id"> <xsl:variable name="thisId" select="."/> <!-- Output "NL" + "id" --> <xsl:text> </xsl:text> <xsl:value-of select="."/> <xsl:text>,</xsl:text> <!-- Output the corresponding "value" for every "id" --> <xsl:for-each select="msxsl:node-set($uniqueNames)/name"> <xsl:variable name="thisName" select="."/> <xsl:value-of select="$Root/root/data/item[@id=$thisId~[@name=$thisName~[1~/@value"/> <xsl:if test="position() != last()"> <xsl:text>,</xsl:text> </xsl:if> </xsl:for-each> </xsl:for-each> </xsl:template> </xsl:stylesheet> >

Further additional information

<root> <data> <item id='1' name='age' value='25' /> <item id='2' name='age' value='27' /> <item id='2' name='cool' value='no' /> <item id='1' name='cool' value='yes' /> </data> </root>

---

Rate this article on a scale of 1 to 10 (1 votes, average 5)

Your vote : 1 2 3 4 5 6 7 8 9 10  

Updating...

<< System.XML		.NET and XML (67)Ajax (2)BizTalk (55)CSS (114)JavaScript (64)LAMP (6)Microsoft ASP (90)PHP XML (89)reBlogger (0)Schemas, xsd, xdr (45)SEO (3)SQL XML (76)System.XML (39)Uncategorized (110)WCF, WS, SOAP (55)XALAN (22)XHTML (97)XML DOM (119)XmlSerializer (34)XQuery (24)XSLT (279)	WCF, WS, SOAP >>

Updating comments...

---

Updating comments...

Leave a comment for this article
Your name
Your email (optional)
Your comment
Optional: Upload an attachment
Enter the code shown: