使用XSLT - 加入从XML多个节点的值(Join values from multiple n

这是一个测试XML不是原始的XML。 我需要去拉那些博客网站仅适用于在bloggrs块存在博主ID。 是否有可能使用XSLT只？ 我认为事实并非如此。

<root>
<bloggers>
<name bloggerId = "1">Jacob Sebastian</name>
<name bloggerId = "2">Adam Machanic</name>
<name bloggerId = "3">Pinal Dave</name>
<name bloggerId = "4">Steve Jones</name>
<name bloggerId = "5">Michael Coles</name>
</bloggers>
<blogs>
<url bloggerId = "1">http://www.sqlblog.com/adam_machanic </url>
<url bloggerId = "2">http://www.sqlauthority.com </url>
<url bloggerId = "3">http://www.beyondrelational.com </url>
<url bloggerId = "4">http://www.sqlblog.com/michael_coles </url>
<url bloggerId = "5">http://www.sqlservercentral.com/blogs/steve_jones </url>
<url bloggerId = "6">http://www.cnn.com/belief </url>
<url bloggerId = "7">http://www.yahoo.com/360 </url>
</blogs>
</root>

我的输出是这种形式

+-------+----------+
| Site  | Blogger  |
+-------+----------+
| site1 | blogger1 |
| site2 | blogger2 |
+-------+----------+

该列表将排除网站6和7，因为这些博客数量不存在的博客。

Answer 1:

<xsl:stylesheet version="1.0"
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:template match="/">
        <table border="1">
            <xsl:apply-templates select="//url" />
        </table>
    </xsl:template>

    <xsl:template match="url">
        <xsl:variable name="id" select="@bloggerId" />

        <xsl:if test="count(//bloggers//name[@bloggerId = $id]) &gt; 0">
            <tr>
                <td>
                    <xsl:value-of select="//bloggers//name[@bloggerId = $id]" />
                </td>
                <td>
                    <xsl:value-of select="." />
                </td>
            </tr>
        </xsl:if>
    </xsl:template>
</xsl:stylesheet>

Answer 2:

即使XPath是不够的： //blogs/url[@bloggerId = //bloggers/@bloggerId]

Answer 3:

此短而简单（无xsl:variable ，没有xsl:if ）变换 ：

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
 <xsl:output omit-xml-declaration="yes" indent="yes"/>

 <xsl:template match="/*">
  <table border="1">
   <thead>
     <th>Site</th><th>Blogger</th>
   </thead>
   <tbody>
    <xsl:apply-templates/>
   </tbody>
  </table>
 </xsl:template>

 <xsl:template match=
  "url[@bloggerId = /*/bloggers/name/@bloggerId]">
   <tr>
     <td><a href="{.}"><xsl:value-of select="."/></a></td>
     <td><xsl:value-of select=
     "/*/bloggers/name[@bloggerId = current()/@bloggerId]"/></td>
   </tr>
 </xsl:template>
 <xsl:template match="text()"/>
</xsl:stylesheet>

当施加在提供的XML文档 ：

<root>
    <bloggers>
        <name bloggerId = "1">Jacob Sebastian</name>
        <name bloggerId = "2">Adam Machanic</name>
        <name bloggerId = "3">Pinal Dave</name>
        <name bloggerId = "4">Steve Jones</name>
        <name bloggerId = "5">Michael Coles</name>
    </bloggers>
    <blogs>
        <url bloggerId = "1">http://www.sqlblog.com/adam_machanic</url>
        <url bloggerId = "2">http://www.sqlauthority.com</url>
        <url bloggerId = "3">http://www.beyondrelational.com</url>
        <url bloggerId = "4">http://www.sqlblog.com/michael_coles</url>
        <url bloggerId = "5">http://www.sqlservercentral.com/blogs/steve_jones</url>
        <url bloggerId = "6">http://www.cnn.com/belief</url>
        <url bloggerId = "7">http://www.yahoo.com/360</url>
    </blogs>
</root>

产生想要的，正确的结果 ：

<table border="1">
   <thead>
      <th>Site</th>
      <th>Blogger</th>
   </thead>
   <tbody>
      <tr>
         <td>
            <a href="http://www.sqlblog.com/adam_machanic">http://www.sqlblog.com/adam_machanic</a>
         </td>
         <td>Jacob Sebastian</td>
      </tr>
      <tr>
         <td>
            <a href="http://www.sqlauthority.com">http://www.sqlauthority.com</a>
         </td>
         <td>Adam Machanic</td>
      </tr>
      <tr>
         <td>
            <a href="http://www.beyondrelational.com">http://www.beyondrelational.com</a>
         </td>
         <td>Pinal Dave</td>
      </tr>
      <tr>
         <td>
            <a href="http://www.sqlblog.com/michael_coles">http://www.sqlblog.com/michael_coles</a>
         </td>
         <td>Steve Jones</td>
      </tr>
      <tr>
         <td>
            <a href="http://www.sqlservercentral.com/blogs/steve_jones">http://www.sqlservercentral.com/blogs/steve_jones</a>
         </td>
         <td>Michael Coles</td>
      </tr>
   </tbody>
</table>

文章来源: Join values from multiple nodes in XML - using XSLT