使用XSLT合并2个具有匹配"id"属性的XML文件 [英] Merge 2 XML files with matching 'id' attribute using XSLT

问题描述

我想在匹配"id"属性时使用XSLT合并2个XML文件.

I want to merge 2 XML files using XSLT when there is matching 'id' attribute.

myFile1.xml(这是第一个输入文件)

myFile1.xml (This is the first input file)

    <?xml version="1.0" encoding="ISO-8859-1"?>
    <test>
      <node>
        <type id="a">
          <name>joe</name>
          <name>kill</name>
        </type>
      </node>
      <node>
        <type id="b">
          <name>sam</name>
        </type>
      </node>
    </test>

myFile2.xml(这是第二个输入文件)

myFile2.xml (This is the second input file)

    <?xml version="1.0" encoding="ISO-8859-1"?>
    <test>
      <node>
        <type id="a">
        <name>jill</name>
        <name>kill</name>
        </type>
      </node>
    </test>

mergeOutput.xml(这是预期的输出，其中ID匹配且2个文件被合并)

mergeOutput.xml (This is expected output where id is matched and 2 files are merged)

    <?xml version="1.0" encoding="ISO-8859-1"?>
    <test>
      <node>
        <type id="a">
          <name>joe</name>
         <name>jill</name> 
          <name>Kill</name>
        </type>
      </node>
      <node>
        <type id="b">
          <name>sam</name>
        </type>
      </node>
    </test>

任何XSLT代码或指向该代码的链接都将有所帮助.我没有XSLT知识，无法使用这种合并来使事情正常进行.

Any XSLT code or link to the code would be helpful. I am not having XSLT knowledge and using this merge to get things working.

推荐答案

<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:transform version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:output method="xml" version="1.0" encoding="ISO-8859-1" indent="yes" />
  <xsl:variable name="with" select="'myFile2.xml'" />
  <xsl:template match="@*|node()">
    <xsl:copy>
      <xsl:apply-templates select="@*|node()" />
    </xsl:copy>
  </xsl:template>

  <xsl:template match="//type">
    <xsl:copy>
      <xsl:apply-templates select="@*|node()" />
      <xsl:variable name="info" select="document($with)/test/node/type[@id=current()/@id]/." />
     <xsl:for-each select="$info/*">
          <xsl:copy-of select="." />
      </xsl:for-each>
    </xsl:copy>
  </xsl:template>
</xsl:transform>

此转换的输出为(请参见kill是重复的)-

The output of this transform is (See kill is duplicated) -

<?xml version="1.0" encoding="ISO-8859-1"?>
<test>
    <node>
        <type id="a">
            <name>joe</name>
            <name>kill</name>
            <name>jill</name>
            <name>kill</name>
        </type>
    </node>
    <node>
        <type id="b">
            <name>sam</name>
        </type>
    </node>
</test>

这篇关于使用XSLT合并2个具有匹配"id"属性的XML文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！