Meunchian grouping with concat of 3 keys
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.
精彩评论