Hello,

I am having some issues trying to merge two files, and am hoping someone may be able to help me out...

So, for example, lets say I have 2 XML files:

File1.xml
<parts>
  <part partNumber="123456" description="Widget" />
  <part partNumber="121212" description="Widget2" />
</parts>

File2.xml

<partInformation>
  <part partNumber="123456" description="Widget" />
    <specification name="12" version="2" />
    <type="Widget" />
  </part>
  <part partNumber="121212" description="Widget2" />
    <specification name="11" version="4" />
    <type="Widget" />
  </part>
</partInformation>

The second file will have a list of a ton of different parts and specifics about them. The output I need would be something like:

<parts>
  <part partNumber="123456" description="Widget" />
    <specification name="12" version="2" />
    <type="Widget" />
  </part>
  <part partNumber="121212" description="Widget2" />
    <specification name="11" version="4" />
    <type="Widget" />
  </part>
</parts>

If anyone could guide me in the right direction for figuring this out, It would be greatly appreciated!

Thanks in advance!

You need something along the lines of this.

Use File1.xml as the principal source document.

<xsl:key name="p" match="part" use="partNumber">

<xsl:template match="/">
<parts>
  <xsl:for-each select="parts/part">
    <part partNumber="{@partNumber}" description="{@description}">
      <xsl:copy-of select="key('p', @partNumber, document('File2.xml'))/*"/>
    </part>
  </xsl:for-each>
</parts>

Thats XSLT 2.0 syntax (key() with 3 arguments). In 1.0 you have to change the xsl:copy-of to

<xsl:variable name="partNr" select="@partNumber"/>
<xsl:for-each select="document('File2.xml')"/>
   <xsl:copy-of select="key('p', $partNr)/*"/>
</xsl:for-each>

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

Hello, thank you for your reply! Sorry for the slow response, was out last week.

I have given the code segment a shot that is listed below, but it appears key() accepts only two arguments, not three. I am not sure how to incorporate the second document in the XSLT so it will look there. Any suggestions?

If you read the reply more carefully you'll see that you need XSLT 2.0 for the three argument version, if you are using version 1.0 you need the xsl:for-each kludge.

--

Joe (Microsoft MVP - XML)

Sorry, I was assuming the processor with VS2005 would process using 2.0. Apparently not. Saxon works better, but not giving me the correct output. It has put me in the right direction, however. Thanks!