I need to create another XML similar to my source XML but I will have to test whether three child nodes contains specific information as follows

  Qual_A = Data A and
  Qual_B = Data B and
  Qual_C = Data C

So the resulting XML will contain rows 1, 3 and 4 only

Finding the row using Xpath below is not a problem

  //column[@name='Qual_A']/text()='Data A' and column[@name='Qual_B']/text()='Data B' and column[@name='Qual_C']/text()='Data C'

But I'm lost in using the following XSLT instructions to build the XML

- copy
- copy-of-select + xpath above
- if + xpath above



Thanks for the usual support!


==========
source XML
==========

<row>
 <column name="Qual_A">Data A</column>
 <column name="Qual_B">Data B</column>
 <column name="Qual_C">Data C</column>
 <column name="Qual_D">Get Me First</column>
</row>
<row>
 <column name="Qual_A">Data A</column>
 <column name="Qual_B">Data B</column>
 <column name="Qual_C">Data B</column>
 <column name="Qual_D">Data B</column>
</row>
<row>
 <column name="Qual_A">Data A</column>
 <column name="Qual_B">Data B</column>
 <column name="Qual_C">Data C</column>
 <column name="Qual_D">Get Me Second</column>
</row>
<row>
 <column name="Qual_A">Data A</column>
 <column name="Qual_B">Data B</column>
 <column name="Qual_C">Data C</column>
 <column name="Qual_D">Get Me Third</column>
</row>
.
.
.
.

>Finding the row using Xpath below is not a problem

  //column[@name='Qual_A']/text()='Data A' and column[@name='Qual_B']/text()='Data B' and column[@name='Qual_C']/text()='Data C'


that's right except for the initial "//" which means that you will succeed if there is a Qual A/Data A anywhere in the document, not just in the current row.

You can just use

<xsl:copy-of select="row[column[@name='Qual_A']/text()='Data A' and column[@name='Qual_B']/text()='Data B' and column[@name='Qual_C']/text()='Data C'
]"/>

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Hi Michael,

Thanks for noting the issue on using '//'...

My problem earlier was I introduced too much instructions on XSLT (copy/copy of select/ if /apply templates select/ etc...) when all I need is a simple solution that requires 2 lines of XSLT code.

Cheers!