Recreating the XML

nelly78 · April 18th, 2011, 10:44 AM

Hi All,
I want to reproduce xml using xslt, if there are multiple record of the same 'Name' element
then in the new XML only single record should appear which has latest Modify time.

Example XML
===========

Code:

<Display>
   <Results>
     <Result>
        <ModifyDate>20110412</ModifyDate>
        <ModifyTime>161144</ModifyTime>
        <Name>Test.txt</Name>
     </Result>
     <Result>
        <ModifyDate>20110412</ModifyDate>
        <ModifyTime>161211</ModifyTime>
        <Name>Test.txt</Name>
     </Result>
      <Result>
        <ModifyDate>20110310</ModifyDate>
        <ModifyTime>140502</ModifyTime>
        <Name>Usert.doc</Name>
     </Result>
   </Results>
</Display>

Want to produce below xml.
Desired XML
===========

Code:

<Display>
   <Results>     
     <Result>
        <ModifyDate>20110412</ModifyDate>
        <ModifyTime>161211</ModifyTime>
        <Name>Test.txt</Name>
     </Result>
      <Result>
        <ModifyDate>20110310</ModifyDate>
        <ModifyTime>140502</ModifyTime>
        <Name>Usert.doc</Name>
     </Result>
   </Results>
</Display>

Could someone please give some hint how to achieve this.

Thanks
-Nelly

nelly78 · April 19th, 2011, 06:16 AM

Could someone please shed some light on it....or give some hint please.

Thanks
Nelly

Martin Honnen · April 19th, 2011, 06:56 AM

Do you want to use XSLT 2.0 or 1.0? With 2.0 you can simply group with for-each-group and then take the max date and/or time (I am not sure what you want).

nelly78 · April 19th, 2011, 07:26 AM

Hi Martin,

Thank you very much for your reply. I want to use XSLT 2.0.

If you could provide some example code that will reply helpful.

Thanks Again
-Nelly

Martin Honnen · April 19th, 2011, 07:34 AM

Here is a sample, it groups using for-each-group, then sorts based on the provided date and time to take the item with latest date/time:

Code:

<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes" />

<xsl:template match="@* | node()">
  <xsl:copy>
    <xsl:apply-templates select="@*, node()"/>
  </xsl:copy>
</xsl:template>

<xsl:template match="Results">
  <xsl:copy>
    <xsl:for-each-group select="Result" group-by="Name">
      <xsl:for-each select="current-group()">
        <xsl:sort select="ModifyDate + ModifyTime" order="descending"/>
        <xsl:if test="position() eq 1">
          <xsl:apply-templates select="."/>
        </xsl:if>
      </xsl:for-each>
    </xsl:for-each-group>
  </xsl:copy>
</xsl:template>

</xsl:stylesheet>

nelly78 · April 19th, 2011, 10:22 AM

Hi Martin

I am getting error on the below line on the ','

<xsl:apply-templates select="@*, node()"/>

It should be '|' instead of ',' or something else?

Thanks
Nelly

Martin Honnen · April 19th, 2011, 10:35 AM

You can use
select="@* | node()"
if you want or need to but the comma should work with any compliant XSLT 2.0 processor.

nelly78 · April 19th, 2011, 10:45 AM

Thanks Martin for your reply.

I am using .net's 'System.Xml.Xsl.XslTransform(); and came to know that It doesn't support XSLT 2.0.

Could you please give some hint what is the alternate of the 2.0 in 1.0.

What changes I need to do to work with xslt 1.0.

Inestead of 'xsl:for-each-group' what can I use to achieve that.

Thanks
-Nelly

Martin Honnen · April 19th, 2011, 10:50 AM

With XSLT 1.0 you need to use Muenchian grouping instead of the for-each-group, grouping in XSLT 1.0 is described on http://www.jenitennison.com/xslt/grouping/index.xml.

nelly78 · April 19th, 2011, 12:45 PM

Hi Martin,

I am trying with the below XSLT but not getting proper result:

Code:

 
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheetxmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:xd="http://www.oxygenxml.com/ns/doc/xsl" version="1.0">
<xsl:key name="Results-by-name" match="contact" use="Name"/>
<xsl:template match="@*|node()">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>
<xsl:template match="Display">
<Display>
<xsl:apply-templates/>
</Display>
</xsl:template><xsl:template match="Results">
<xsl:copy>
<Results>
<xsl:apply-templates select="Result"></xsl:apply-templates>
</Results></xsl:copy>
</xsl:template><xsl:template match="Result"><xsl:for-each select="Result[count(. | key('Results-by-name', Name)[1]) = 1]"><xsl:for-each select="key('Results-by-name', Name)">
<xsl:sort select="OTModifyDate + OTModifyTime" order="descending"/><xsl:apply-templates select="."/></xsl:for-each></xsl:for-each>
</xsl:template>
</xsl:stylesheet>

Regards
Yunus