开发者

Meunchian grouping with concat of 3 keys

开发者 https://www.devze.com 2023-03-08 05:46 出处:网络
I know this might be simple but i tried a lot to find answer by looking at some similar questions like this. The meunchian grouping with concat of 3 keys works fine, but what if the input does not req

I know this might be simple but i tried a lot to find answer by looking at some similar questions like this. The meunchian grouping with concat of 3 keys works fine, but what if the input does not require to be grouped. I have provided sample xsl below.The output i get when i run the transform does not create the CLM node if there is only one occurence of CLM node. Thanks in advance.

the input file

<?xml version="1.0" encoding="utf-8"?>
<PRV ProviderId="100" PName="Giga health"
Provsuv="1563">
    <CLT ClientId="4444" ClientFName="John"
      ClientLastName="Pulaski" Phone="56462561">开发者_StackOverflow
        <CLM Claimid="1"  DateOfService="01/02/2011"
          EndOfService="05/05/2011" ServiceId="S1"
          WorkerName="WORK1" WorkerId="6446"
          Unit= '5' Amount= '5000'/>
        <CLM Claimid="2"  DateOfService="01/02/2011"
         EndOfService="05/05/2011" ServiceId="S1"
         WorkerName="WORK1" WorkerId="6446"
         Unit= '6' Amount= '5000'/>
        <CLM Claimid="3"  DateOfService="01/02/2011"
         EndOfService="05/05/2011" ServiceId="S2"
         WorkerName="WORK1" WorkerId="2006"
         Unit= '7' Amount= '5000'/>
        <CLM Claimid="4"  DateOfService="01/03/2011"
         EndOfService="05/05/2011" ServiceId="S1"
         WorkerName="WOK2" WorkerId="6446"
         Unit= '3' Amount= '5000'/>
        <CLM Claimid="5"  DateOfService="01/03/2011"
         EndOfService="05/05/2011" ServiceId="S2"
         WorkerName="WORK2" WorkerId="6446"
         Unit= '8' Amount= '5000'/>
        <CLM Claimid="6" DateOfService="01/03/2011"
         EndOfService="05/05/2011" ServiceId="S2"
         WorkerName="WORK1" WorkerId="6446"
         Unit= '1' Amount= '5000'/>
    </CLT>
    <CLT ClientId="4444" ClientFName="John"
      ClientLastName="Pulaski" Phone="56462561">
        <CLM Claimid="1"  DateOfService="01/02/2011"
          EndOfService="05/05/2011" ServiceId="S1"
          WorkerName="WORK1" WorkerId="6446"
         Unit= '5' Amount= '5000'/>
    </CLT>
</PRV>

the xsl applied to this input,

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

    <xsl:key name="kCLMByAttribs" match="CLM" use=
 "concat(@ServiceId,'+',@WorkerId,'+',@DateOfService)"/>

    <xsl:template match="node()|@*">
        <xsl:copy>
            <xsl:apply-templates select="node()|@*"/>
        </xsl:copy>
    </xsl:template>

    <xsl:template match=
 "CLM[generate-id()
     =
      generate-id(key('kCLMByAttribs',
                      concat(@ServiceId,
                            '+',@WorkerId,
                            '+',@DateOfService)
                     )
                     [1]
                 )
     ]
 ">
        <xsl:copy>
            <xsl:copy-of select="@*"/>

            <xsl:variable name="vGroup" select=
   "key('kCLMByAttribs',
         concat(@ServiceId,
                '+',@WorkerId,
                '+',@DateOfService)
       )
   "/>

            <xsl:variable name="vClaimIds">
                <xsl:for-each select="$vGroup">
                    <xsl:if test="not(position()=1)">
                        <xsl:value-of select="','"/>
                    </xsl:if>
                    <xsl:value-of select="@Claimid"/>
                </xsl:for-each>
            </xsl:variable>

            <xsl:attribute name="Claimid">
                <xsl:value-of select="$vClaimIds"/>
            </xsl:attribute>

            <xsl:attribute name="Unit">
                <xsl:value-of select="sum($vGroup/@Unit)"/>
            </xsl:attribute>
        </xsl:copy>
    </xsl:template>

    <xsl:template match="CLM"/>
</xsl:stylesheet>

The desired output

<PRV ProviderId="100" PName="Giga health" Provsuv="1563">
  <CLT ClientId="4444" ClientFName="John" ClientLastName="Pulaski" Phone="56462561">
    <CLM DateOfService="01/02/2011" EndOfService="05/05/2011" ServiceId="S1" WorkerName="WORK1" WorkerId="6446" Amount="5000" Claimid="1,2" Unit="16" />
    <CLM DateOfService="01/02/2011" EndOfService="05/05/2011" ServiceId="S2" WorkerName="WORK1" WorkerId="2006" Amount="5000" Claimid="3" Unit="7" />
    <CLM DateOfService="01/03/2011" EndOfService="05/05/2011" ServiceId="S1" WorkerName="WOK2" WorkerId="6446" Amount="5000" Claimid="4" Unit="3" />
    <CLM DateOfService="01/03/2011" EndOfService="05/05/2011" ServiceId="S2" WorkerName="WORK2" WorkerId="6446" Amount="5000" Claimid="5,6" Unit="9" />
  </CLT>
  <CLT ClientId="4444" ClientFName="John" ClientLastName="Pulaski" Phone="56462561">
      <CLM Claimid="1"  DateOfService="01/02/2011" EndOfService="05/05/2011" ServiceId="S1" WorkerName="WORK1" WorkerId="6446" Unit= '5' Amount= '5000'/>
  </CLT>  
</PRV>


The easiest change to get your expected result would be to let your key include generate-id(..):

<PRV ProviderId="100" PName="Giga health" Provsuv="1563">
  <CLT ClientId="4444" ClientFName="John" ClientLastName="Pulaski" Phone="56462561">
    <CLM Claimid="1,2" DateOfService="01/02/2011" EndOfService="05/05/2011" ServiceId="S1" WorkerName="WORK1" WorkerId="6446" Unit="11" Amount="5000"/>
    <CLM Claimid="3" DateOfService="01/02/2011" EndOfService="05/05/2011" ServiceId="S2" WorkerName="WORK1" WorkerId="2006" Unit="7" Amount="5000"/>
    <CLM Claimid="4" DateOfService="01/03/2011" EndOfService="05/05/2011" ServiceId="S1" WorkerName="WOK2" WorkerId="6446" Unit="3" Amount="5000"/>
    <CLM Claimid="5,6" DateOfService="01/03/2011" EndOfService="05/05/2011" ServiceId="S2" WorkerName="WORK2" WorkerId="6446" Unit="9" Amount="5000"/>
  </CLT>
  <CLT ClientId="4444" ClientFName="John" ClientLastName="Pulaski" Phone="56462561">
    <CLM Claimid="1" DateOfService="01/02/2011" EndOfService="05/05/2011" ServiceId="S1" WorkerName="WORK1" WorkerId="6446" Unit="5" Amount="5000"/>
  </CLT>
</PRV>

Note that this results in Claimid="1,2" for the first CLM node under the first CLT node, as this as what I assume you want.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号