如何正确使用Muenchian按元素对非常重复的标签进行分组?

Question

>我在使用Muenchian时遇到了问题。我有一个非常大的 xml 要转换为新的输出。我已经构建了 xsl 以使用元素作为"父级"进行分组的键，并将所有内容作为子级返回。源对不同的子级多次使用相同的父级，但它只带来了第一个。

<?xml version="1.0" encoding="UTF-8" standalone="no" ?><Calculate_Account_Level_S6>

<Account_Number_ANI_ID17>7700.401100.900</Account_Number_ANI_ID17>
<Description001_ID19>A/P ThirdParty</Description001_ID19>
<Parent_Account_Number_ANI_ID21>401100.900</Parent_Account_Number_ANI_ID21>
<DebitCreditAccount_ID26>A</DebitCreditAccount_ID26>
<Account_Group_Gen_ID28>MX2010101</Account_Group_Gen_ID28>
</Calculate_Account_Level_S6>
<Calculate_Account_Level_S6>
<Account_Number_ANI_ID17>7700100.401100.900</Account_Number_ANI_ID17>
<Description001_ID19>A/P ThirdParty</Description001_ID19>
<Parent_Account_Number_ANI_ID21>401100.900</Parent_Account_Number_ANI_ID21>
<DebitCreditAccount_ID26>A</DebitCreditAccount_ID26>
<Account_Group_Gen_ID28>MX2010101</Account_Group_Gen_ID28>
</Calculate_Account_Level_S6>
<Calculate_Account_Level_S6>
<Account_Number_ANI_ID17>7700101.401100.900</Account_Number_ANI_ID17>
<Description001_ID19>A/P ThirdParty</Description001_ID19>
<Parent_Account_Number_ANI_ID21>401100.900</Parent_Account_Number_ANI_ID21>
<DebitCreditAccount_ID26>A</DebitCreditAccount_ID26>
<Account_Group_Gen_ID28>MX2010101</Account_Group_Gen_ID28>
</Calculate_Account_Level_S6>
XSL KEY:
<xsl:key name="GrpParentAccount" match="/RLA70901/Generic_Char_of_Account_Generation_S5/Calculate_Account_Level_S6" use="Parent_Account_Number_ANI_ID21" />
<xsl:key name="Account" match="/RLA70901/Generic_Char_of_Account_Generation_S5/Calculate_Account_Level_S6" use="Account_Number_ANI_ID17" />
Coding:
<xsl:for-each select="/RLA70901/Generic_Char_of_Account_Generation_S5/Calculate_Account_Level_S6[count(. | key('GrpParentAccount', Parent_Account_Number_ANI_ID21)[1]) = 1]">
<xsl:sort select="Parent_Account_Number_ANI_ID21"/>
<xsl:sort select="Account_Number_ANI_ID17"/>
<catalogocuentas:Ctas>
<xsl:attribute name="CodAgrup">
<xsl:value-of select="substring(Account_Group_Gen_ID28,3.0,3.0)"/>
</xsl:attribute>
<xsl:attribute name="NumCta">
<xsl:value-of select="Parent_Account_Number_ANI_ID21"/>
</xsl:attribute>
<xsl:attribute name="Desc">
<xsl:value-of select="Converted_Account_Description_ID29"/>
</xsl:attribute>
<xsl:attribute name="SubCtaDe">
<xsl:text disable-output-escaping="no"></xsl:text>
</xsl:attribute>
<xsl:attribute name="Nivel">
<xsl:text disable-output-escaping="no">1</xsl:text>
</xsl:attribute>
<xsl:attribute name="Natur">
<xsl:value-of select="DebitCreditAccount_ID26"/>
</xsl:attribute>
</catalogocuentas:Ctas>
<!-- Grouping End -->
<!-- Printing All Accounts by Group -->
<xsl:for-each select="/RLA70901/Generic_Char_of_Account_Generation_S5/Calculate_Account_Level_S6[count(. | key('Account', Account_Number_ANI_ID17)[1]) = 1]">-->
<catalogocuentas:Ctas>
<xsl:attribute name="CodAgrup">
<xsl:value-of select="substring(Account_Group_Gen_ID28,3.0,5.0)"/>
</xsl:attribute>
<xsl:attribute name="NumCta">
<xsl:value-of select="Account_Number_ANI_ID17"/>
</xsl:attribute>
<xsl:attribute name="Desc">
<xsl:value-of select="Converted_Account_Description_ID29"/>
</xsl:attribute>
<xsl:if test='Parent_Account_Number_ANI_ID21 != ""'>
<xsl:attribute name="SubCtaDe">
<xsl:value-of select="Parent_Account_Number_ANI_ID21"/>
</xsl:attribute>
</xsl:if>
<xsl:attribute name="Nivel">
<xsl:text disable-output-escaping="no">2</xsl:text>
</xsl:attribute>
<xsl:attribute name="Natur">
<xsl:value-of select="DebitCreditAccount_ID26"/>
</xsl:attribute>
</catalogocuentas:Ctas>
</xsl:for-each>
</xsl:for-each>
</catalogocuentas:Catalogo>
<catalogocuentas:Ctas CodAgrup="201" NumCta="401100.900" Desc="Proveedores IVA 16%" SubCtaDe="" Nivel="1" Natur="A"/><catalogocuentas:Ctas CodAgrup="20101" NumCta="7700.401100.900" Desc="Proveedores IVA 16%" SubCtaDe="401100.900" Nivel="2" Natur="A"/></catalogocuentas:Catalogo>
I was expecting to print all Calculate_Account_Level_S6/Account_Number_ANI_ID17 by the Calculate_Account_Level_S6/Parent_Account_Number_ANI_ID21 Any help is very WELCOME !!! :)

Answer 1

尝试将第二个键从

<xsl:key name="Account" match="/RLA70901/Generic_Char_of_Account_Generation_S5/Calculate_Account_Level_S6" use="Account_Number_ANI_ID17" />

自

<xsl:key name="Account" match="/RLA70901/Generic_Char_of_Account_Generation_S5/Calculate_Account_Level_S6" use="concat(Account_Number_ANI_ID17, '|', Account_Number_ANI_ID17)" />

和内for-each来自

<xsl:for-each select="/RLA70901/Generic_Char_of_Account_Generation_S5/Calculate_Account_Level_S6[count(. | key('Account', Account_Number_ANI_ID17)[1]) = 1]">

自

<xsl:for-each select="key('GrpParentAccount', Parent_Account_Number_ANI_ID21)[count(. | key('Account', concat(Account_Number_ANI_ID17, '|', Account_Number_ANI_ID17))[1]) = 1]">