I've been struggling for a while to get two (or more) XML files to be processed by the same xsl file.

I followed the steps in this post: [Including an XML file in an XML/XSL file](https://stackoverflow.com/questions/4703312/including-an-xml-file-in-an-xml-xsl-file) but I haven't been able to get this to work.

I can't seem to get the file loaded to be processed, no error.

This is the first xm file - Dial\_Stats\_MWB:

```
<?xml version="1.0" encoding="utf-8"?>
<UK_Products_Pipeline>
  <LastFinishCode>
    <SiteName>UK</SiteName>
    <LastFinishCode>Agent Logout</LastFinishCode>
    <Numbers>1</Numbers>
  </LastFinishCode>
  <LastFinishCode>
    <SiteName>UK</SiteName>
    <LastFinishCode>Busy</LastFinishCode>
    <Numbers>1</Numbers>
  </LastFinishCode>
  <LastFinishCode>
    <SiteName>UK</SiteName>
    <LastFinishCode>BW Sale</LastFinishCode>
    <Numbers>1</Numbers>
  </LastFinishCode>
</UK_Products_Pipeline>

```

The second file - Dial\_Stats\_UK:

```
<?xml version="1.0" encoding="utf-8"?>
<UK_Products_Pipeline>
  <LastFinishCode>
    <SiteName>MWB</SiteName>
    <LastFinishCode>Bearer Capability Not Presently Authorized (ISDN Cause Code 57)</LastFinishCode>
    <Numbers>1</Numbers>
  </LastFinishCode>
  <LastFinishCode>
    <SiteName>MWB</SiteName>
    <LastFinishCode>Confirmed Booking</LastFinishCode>
    <Numbers>1</Numbers>
  </LastFinishCode>
  <LastFinishCode>
    <SiteName>MWB</SiteName>
    <LastFinishCode>Lost</LastFinishCode>
    <Numbers>1</Numbers>
  </LastFinishCode>
</UK_Products_Pipeline>

```

And the XSL file:

```
<?xml version="1.0" encoding='utf-8'?>
<xsl:stylesheet xmlns:msxsl="urn:schemas-microsoft-com:xslt" version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:output method="html"/>
  <xsl:template match="/">
    <html>
      <head>
        <title> XSLT with XML included </title>
      </head>
      <body style="background-color:lightblue;color:green">
        <table cellSpacing="0" border="1" cellPadding="2">
          <!-- Set Variables -->
          <xsl:variable name="external">
            <xsl:copy-of select="document('D:\DATA\Marquee\dial_stats_UK.xml')/*"/>
          </xsl:variable>
          <!-- Process Data Start -->
          <xsl:for-each select="//UK_Products_Pipeline/LastFinishCode">
            <tr>
           <xsl:if test="SiteName ='MWB'">
                <td>
                  <xsl:value-of select="SiteName"/>
             </td>
                <td>
                  <xsl:value-of select="LastFinishCode"/>
                </td>
                <td>
                  <xsl:value-of select="Numbers"/>
                </td>
              </xsl:if>
            </tr>
          </xsl:for-each>
          <!-- Process File Data Start -->
            <xsl:call-template name="ExternalData">
            <xsl:with-param name="data" select="$external"/>
           </xsl:call-template>
        </table>
      </body>
    </html>
    </xsl:template>
  <xsl:template name="ExternalData">
    <xsl:param name="data"/>
    <xsl:variable name="external">
      <xsl:copy-of select="document('D:\DATA\Marquee\dial_stats_UK.xml')/*"/>
    </xsl:variable>
    <table cellSpacing="0" border="1" cellPadding="2" style="background-color:white;color:black">
        <tr>
          <td>
            I do see this.
          </td>
        </tr>
        <!-- Process External Data -->
        <xsl:for-each select="//UK_Products_Pipeline/LastFinishCode">
          <tr>
            <td>
              <xsl:value-of select="SiteName"/>
            </td>
          </tr>
          <tr>
          <xsl:if test="SiteName ='UK'">
            <td>
              <xsl:value-of select="SiteName"/>
            </td>
            <td>
              <xsl:value-of select="LastFinishCode"/>
            </td>
            <td>
              <xsl:value-of select="Numbers"/>
            </td>
          </xsl:if>
        </tr>
      </xsl:for-each>
    </table>
  </xsl:template>
</xsl:stylesheet>

```

When the processing takes place the same file is processed again not the second file.

I don't know whether or not you can give me any suggestions on what I do wrong here please?