Re: [xsl] Sort an xml file by the using the ordering/sorting information from another xml file

Subject: Re: [xsl] Sort an xml file by the using the ordering/sorting information from another xml file
From: "Mukul Gandhi" <gandhi.mukul@xxxxxxxxx>
Date: Thu, 11 May 2006 14:06:18 +0530
Please try this

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"

<xsl:output method="xml" indent="yes" />

<xsl:variable name="doc" select="/" />
<xsl:variable name="sortorder" select="document('SortingOrder.xml')" />

<xsl:template match="/myRoot">
  <xsl:for-each select="$sortorder/mySortingOrder/myElement">
    <xsl:copy-of select="$doc/myRoot/myElement[@key = current()/@key]" />



On 5/11/06, Jagsmiles <jagsmiles@xxxxxxxxx> wrote:
I want to sort the elements of an xml file, The criteria of ordering is
actually specified in another xml file.

Can i use xsl to sort one xml file by the using the ordering data from
another xml file?:

I give a small e.g.

The Original xml file: main.xml

       <myElement key=3D"Tokyo" country=3D"JAP">I am Tokyo</myElement>
       <myElement key=3D"NewYork" country=3D"US">I am NewYork</myElement>
       <myElement key=3D"Sydney" country=3D"AUS">I am Sydney</myElement>
       <myElement key=3D"London" country=3D"UK">I am London</myElement>

The Sorting Criteria xml file: SortingOrder.xml:
       <myElement key=3D"NewYork" />
       <myElement key=3D"London" />
       <myElement key=3D"Tokyo" />
       <myElement key=3D"Sydney" />

After sorting the final xml data i should get is: <myRoot> <myElement key=3D"NewYork" country=3D"US">I am NewYork</myElement> <myElement key=3D"London" country=3D"UK">I am London</myElement> <myElement key=3D"Tokyo" country=3D"JAP">I am Tokyo</myElement> <myElement key=3D"Sydney" country=3D"AUS">I am Sydney</myElement> </myRoot>

in the final xml, the myElement elements are sorted according to the
order specified in SortingOrder.xml.

Can i achieve this using xsl?
Normally for the xsl:sort the sorting information should be present in the
element itself.

Thanks in advance.

Current Thread