嗨,我有一些员工记录,需要将它们按公司分组并按团队成员的角色进行划分

这是我的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>

请不要出现我的语法错误。我更关注分组逻辑。如果您在当前输出中看到,对于第一家公司,仅出现一个名字,而不是第一个角色的两个名字。请提供帮助。(信息:在一个公司中可以有许多人担任同一角色,而在所有公司中,角色名称都相同。)

dhy12345 回答:嗨,我有一些员工记录,需要将它们按公司分组并按团队成员的角色进行划分

您可以尝试使用此代码

    <?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:xs="http://www.w3.org/2001/XMLSchema"
    exclude-result-prefixes="xs"
    version="2.0">
    <xsl:output method="xml" omit-xml-declaration="yes" indent="yes"/>
    <xsl:template match="root">
        <records>
            <xsl:for-each-group select="records" group-by="CompanyCode">
                <Company>
                    <CompanyCode><xsl:value-of select="current-grouping-key()"/></CompanyCode>
                    <xsl:for-each-group select="current-group()" group-by="TeamMemberRole">
                        <Role>
                            <TeamMemberRole><xsl:value-of select="current-grouping-key()"/></TeamMemberRole>
                            <FirstName><xsl:value-of select="FirstName"/></FirstName>
                            <LastName><xsl:value-of select="LastName"/></LastName>
                        </Role>
                    </xsl:for-each-group>
                </Company>
            </xsl:for-each-group>
        </records>
    </xsl:template>
</xsl:stylesheet>

演示: https://xsltfiddle.liberty-development.net/ej9EGcU/4

本文链接:https://www.f2er.com/3154793.html

大家都在问