atomnyjwzryw@t... wrote:
> On Aug 10, 7:09 pm, Martin Honnen <mahotr...@yahoo.de> wrote:
>> atomnyjwz...@tlen.pl wrote:
>>> how can I group by filename and remove duplicate nodes with attribute
>>> name="nazwa" using XSLT? I want transform one xml to another but I
>>> don't have any idea. Here is an example and expected result.

The following stylesheet should do what you want:

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

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

   <xsl:strip-space elements="*"/>

   <xsl:key name="file-group"
            match="zad"
            use="record/prop[@name='filename']"/>

   <xsl:key name="nazwa-group"
            match="sub"
            use="concat(../../prop[@name='filename'], '_', 
prop[@name='nazwa'])"/>

   <xsl:template match="root">
     <xsl:copy>
       <xsl:apply-templates select="zad[generate-id() = 
generate-id(key('file-group', record/prop[@name='filename'])[1])]"/>
     </xsl:copy>
   </xsl:template>

   <xsl:template match="zad">
     <Obj id="File">
       <Fd name="FileName"><xsl:value-of 
select="record/prop[@name='filename']"/></Fd>
     </Obj>
     <xsl:apply-templates select="key('file-group', 
record/prop[@name='filename'])/record/zbior/sub[generate-id() = 
generate-id(key('nazwa-group', concat(../../prop[@name='filename'], '_', 
prop[@name='nazwa']))[1])]"/>
   </xsl:template>

   <xsl:template match="sub">
     <Obj id="col">
       <xsl:copy-of select="prop"/>
     </Obj>
   </xsl:template>

</xsl:stylesheet>

When run on this input

<root>
	<zad>
	  <record>
	    <prop name="filename">c:\test1</prop>
	    <prop backup="nrbackup">23</prop>
	    <zbior>
	      <sub>
		<prop name="nazwa">a</prop>
		<prop name="level">4</prop>
		<prop name="dom">df</prop>
	      </sub>
	      <sub>
		<prop name="nazwa">b</prop>
		<prop name="level">45</prop>
		<prop name="dom">sd</prop>
	      </sub>
	      <sub>
		<prop name="nazwa">a</prop>
		<prop name="level">4</prop>
		<prop name="dom">df</prop>
	      </sub>
	    </zbior>
	  </record>
	</zad>

	<zad>
	  <record>
	    <prop name="filename">c:\test1</prop>
	    <prop backup="nrbackup">23</prop>
	    <zbior>
	      <sub>
		<prop name="nazwa">a</prop>
		<prop name="level">4</prop>
		<prop name="dom">df</prop>
	      </sub>
	      <sub>
		<prop name="nazwa">c</prop>
		<prop name="level">55</prop>
		<prop name="dom">rt</prop>
	      </sub>
	      <sub>
		<prop name="nazwa">b</prop>
		<prop name="level">45</prop>
		<prop name="dom">sd</prop>
	      </sub>
	    </zbior>
	  </record>
	</zad>

	<zad>
	  <record>
	    <prop name="filename">c:\test2</prop>
	    <prop backup="nrbackup">23</prop>
	    <zbior>
	      <sub>
		<prop name="nazwa">aa</prop>
		<prop name="level">14</prop>
		<prop name="dom">dfa</prop>
	      </sub>
	      <sub>
		<prop name="nazwa">cc</prop>
		<prop name="level">255</prop>
		<prop name="dom">srt</prop>
	      </sub>
	      <sub>
		<prop name="nazwa">aa</prop>
		<prop name="level">14</prop>
		<prop name="dom">dfa</prop>
	      </sub>
	    </zbior>
	  </record>
	</zad>

</root>

it creates the following result:

<root>
    <Obj id="File">
       <Fd name="FileName">c:\test1</Fd>
    </Obj>
    <Obj id="col">
       <prop name="nazwa">a</prop>
       <prop name="level">4</prop>
       <prop name="dom">df</prop>
    </Obj>
    <Obj id="col">
       <prop name="nazwa">b</prop>
       <prop name="level">45</prop>
       <prop name="dom">sd</prop>
    </Obj>
    <Obj id="col">
       <prop name="nazwa">c</prop>
       <prop name="level">55</prop>
       <prop name="dom">rt</prop>
    </Obj>
    <Obj id="File">
       <Fd name="FileName">c:\test2</Fd>
    </Obj>
    <Obj id="col">
       <prop name="nazwa">aa</prop>
       <prop name="level">14</prop>
       <prop name="dom">dfa</prop>
    </Obj>
    <Obj id="col">
       <prop name="nazwa">cc</prop>
       <prop name="level">255</prop>
       <prop name="dom">srt</prop>
    </Obj>
</root>

-- 

	Martin Honnen --- MVP XML
	http://JavaScript.FAQTs.com/