这是我的XML:
<?xml version="1.0" encoding="utf-8"?>
<records>
<CompanyCode>12345</CompanyCode>
<FirstName>Dan<FirstName>
<LastName>Haggerty<LastName>
<TeamMemberRole>CS Director<TeamMemberRole>
</records>
<records>
<CompanyCode>12345</CompanyCode>
<FirstName>And<FirstName>
<LastName>Onemore<LastName>
<TeamMemberRole>CS Director<TeamMemberRole>
</records>
<records>
<CompanyCode>12345</CompanyCode>
<FirstName>And<FirstName>
<LastName>Twomore<LastName>
<TeamMemberRole>DifferentRole<TeamMemberRole>
</records>
<records>
<CompanyCode>54321</CompanyCode>
<FirstName>And<FirstName>
<LastName>Twomore<LastName>
<TeamMemberRole>DifferentRole<TeamMemberRole>
</records>
这是我的必填输出:
<records>
<Company>
<CompanyCode>12345</CompanyCode>
<Role>
<TeamMemberRole>CS Director<TeamMemberRole>
<FirstName>Dan<FirstName>
<LastName>Haggerty<LastName>
<FirstName>And<FirstName>
<LastName>Onemore<LastName>
</Role>
<Role>
<TeamMemberRole>DifferentRole<TeamMemberRole>
<FirstName>And<FirstName>
<LastName>Twomore<LastName>
</Role>
</Company>
<Company>
<CompanyCode>54321</CompanyCode>
<Role>
<TeamMemberRole>DifferentRole<TeamMemberRole>
<FirstName>And<FirstName>
<LastName>Twomore<LastName>
</Role>
</Company>
</records>
我当前的XSL:
<?xml version="1.0" encoding="utf-8"?>
<xsl:output method="xml" indent="yes"/>
<xsl:template match="/">
<xsl:element name="records">
<xsl:for-each-group select="/records" group-by="CompanyCode">
<xsl:element name="Company">
<xsl:value-of select="CompanyCode"/>
<xsl:for-each-group select="current-group()" group-by ="TeamMemberRole">
<xsl: element name "role">
<Role><xsl:value-of select="TeamMemberRole"/><Role>
<FirstName><xsl:value-of select="FirstName"/><FirstName>
<LastName><xsl:value-of select="LastName"/><LastName>
</xsl:element>
</xsl:for-each-group>
</xsl:element>
</xsl:for-each-group>
</xsl:element>
我当前的输出:
<Company>
<CompanyCode>12345</wd:CustomerId>
<Role>
<wd:Role>CS Director</wd:Role>
<wd:FirstName>Dan</wd:FirstName>
<wd:LastName>Haggerty</wd:LastName>
<Role>
<Role>
<Role>DifferentRole</wd:Role>
<wd:FirstName>and</wd:FirstName>
<wd:LastName>twomore</wd:LastName>
<role>
<Company>
<Company>
<CompanyCode>54321</wd:CustomerId>
<Role>
<wd:Role>DifferentRole</wd:Role>
<wd:FirstName>and</wd:FirstName>
<wd:LastName>twomore</wd:LastName>
<Role>
<records>
请不要出现我的语法错误。我更关注分组逻辑。如果您在当前输出中看到,对于第一家公司,仅出现一个名字,而不是第一个角色的两个名字。请提供帮助。(信息:在一个公司中可以有许多人担任同一角色,而在所有公司中,角色名称都相同。)