RE: XML merge

Hi,

> So I have an XML, which contains many same nodes:
> <TABLE_NAME>ConnectionTemp</TABLE_NAME>, and each of them have a
> <COLUMN_NAME>, which are different.
> 
> I'd like make a new XML file from this above, which contains the
> TABLE_NAME node only one for every value of this, and the 
> children of this
> are the COLUMN_NAME nodes. Like this:

Your's is a grouping problem--see Jeni's pages <http://jenitennison.com/xslt/grouping>.

  <xsl:key name="name" match="Table" use="TABLE_NAME" />  
  <xsl:template match="Tables">    
    <xsl:copy>      
      <xsl:for-each select="Table[generate-id(.) = generate-id(key('name', TABLE_NAME))]">        
        <Table name="{TABLE_NAME}">          
          <xsl:for-each select="key('name', TABLE_NAME)">            
            <Column name="{COLUMN_NAME}"/>          
          </xsl:for-each>        
        </Table>      
      </xsl:for-each>    
    </xsl:copy>  
  </xsl:template>

Cheers,

Jarno - Covenant: Speed (Live)

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list