Need some help in Grouping logic using xsl:key

arunprasadlv · May 4th, 2012, 01:42 AM

Hi ,

I need some help with grouping the nodes. Below are input xml and expected output.

input :

<response>
<GetTestWSResponse>
<CardNumber>12345</CardNumber>
<ProgramInfoList>
<ProgramInfo>
<PartnerInformationGrp>
<PartnerId>H</PartnerId>
<ProgId>H00002</ProgId>
</PartnerInformationGrp>
<AmtInformationGrp>
<HighAmt>19999.00</HighAmt>
<LowAmt>0.00</LowAmt>
</AmtInformationGrp>
</ProgramInfo>
<ProgramInfo>
<PartnerInformationGrp>
<PartnerId>H</PartnerId>
<ProgId>H00001</ProgId>
</PartnerInformationGrp>
<AmtInformationGrp>
<HighAmt>24.00</HighAmt>
<LowAmt>2.00</LowAmt>
</AmtInformationGrp>
</ProgramInfo>
<ProgramInfo>
<PartnerInformationGrp>
<PartnerId>H</PartnerId>
<ProgId>H00002</ProgId>
</PartnerInformationGrp>
<AmtInformationGrp>
<HighAmt>19.00</HighAmt>
<LowAmt>12.00</LowAmt>
</AmtInformationGrp>
</ProgramInfo>
<ProgramInfo>
<PartnerInformationGrp>
<PartnerId>H</PartnerId>
<ProgId>H00001</ProgId>
</PartnerInformationGrp>
<AmtInformationGrp>
<HighAmt>1744.00</HighAmt>
<LowAmt>99.00</LowAmt>
</AmtInformationGrp>
</ProgramInfo>

</ProgramInfoList>
</GetTestWSResponse>
</response>

output :

<response>
<GetTestWSResponse>
<CardNumber>12345</CardNumber>
<ProgramInfoList>
<ProgramInfo>
<PartnerInformationGrp>
<PartnerId>H</PartnerId>
<ProgId>H00002</ProgId>
</PartnerInformationGrp>
<AmtInformationGrp>
<HighAmt>19999.00</HighAmt>
<LowAmt>0.00</LowAmt>
</AmtInformationGrp>
<AmtInformationGrp>
<HighAmt>19.00</HighAmt>
<LowAmt>12.00</LowAmt>
</AmtInformationGrp>
</ProgramInfo>
<ProgramInfo>
<PartnerInformationGrp>
<PartnerId>H</PartnerId>
<ProgId>H00001</ProgId>
</PartnerInformationGrp>
<AmtInformationGrp>
<HighAmt>24.00</HighAmt>
<LowAmt>2.00</LowAmt>
</AmtInformationGrp>
<AmtInformationGrp>
<HighAmt>1744.00</HighAmt>
<LowAmt>99.00</LowAmt>
</AmtInformationGrp>
</ProgramInfo>
</ProgramInfoList>
</GetTestWSResponse>
</response>

I tried using xsl:key to find the unique Progid ,but i am not able to figure out how i can get the sibling node for <ProgramInfo>

<xsl:variable name="unique-ProgId" select="//ProgramInfo/PartnerInformationGrp[generate-id(.)=generate-id(key('progId-ref',ProgId))]"/>

<xsl:for-each select="$unique-ProgId">
<result>

<xsl:copy-of select="following::ProgramInfo[PartnerInformationGrp/ProgId= "/>
</result>
</xsl:for-each>

Regards.
Arun

Martin Honnen · May 5th, 2012, 06:06 AM

Here is how I would do it with XSLT 1.0:

Code:

<xsl:stylesheet
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  version="1.0">
  
  <xsl:output method="xml" indent="yes"/>
  <xsl:strip-space elements="*"/>
  
  <xsl:key name="by-ProgId" match="ProgramInfo" use="PartnerInformationGrp/ProgId"/>
  
  <xsl:template match="@* | node()">
    <xsl:copy>
      <xsl:apply-templates select="@* | node()"/>
    </xsl:copy>
  </xsl:template>
  
  <xsl:template match="ProgramInfoList">
    <xsl:copy>
      <xsl:apply-templates select="ProgramInfo[generate-id() = generate-id(key('by-ProgId', PartnerInformationGrp/ProgId)[1])]" mode="group"/>
    </xsl:copy>
  </xsl:template>
  
  <xsl:template match="ProgramInfo" mode="group">
    <xsl:copy>
      <xsl:apply-templates select="PartnerInformationGrp | key('by-ProgId', PartnerInformationGrp/ProgId)/AmtInformationGrp"/>
    </xsl:copy>
  </xsl:template>
  
</xsl:stylesheet>

With that stylesheet the input

Code:

<response>
  <GetTestWSResponse>
    <CardNumber>12345</CardNumber>
    <ProgramInfoList>
      <ProgramInfo>
        <PartnerInformationGrp>
          <PartnerId>H</PartnerId>
          <ProgId>H00002</ProgId>
        </PartnerInformationGrp>
        <AmtInformationGrp>
          <HighAmt>19999.00</HighAmt>
          <LowAmt>0.00</LowAmt>
        </AmtInformationGrp>
      </ProgramInfo>
      <ProgramInfo>
        <PartnerInformationGrp>
          <PartnerId>H</PartnerId>
          <ProgId>H00001</ProgId>
        </PartnerInformationGrp>
        <AmtInformationGrp>
          <HighAmt>24.00</HighAmt>
          <LowAmt>2.00</LowAmt>
        </AmtInformationGrp>
      </ProgramInfo>
      <ProgramInfo>
        <PartnerInformationGrp>
          <PartnerId>H</PartnerId>
          <ProgId>H00002</ProgId>
        </PartnerInformationGrp>
        <AmtInformationGrp>
          <HighAmt>19.00</HighAmt>
          <LowAmt>12.00</LowAmt>
        </AmtInformationGrp>
      </ProgramInfo>
      <ProgramInfo>
        <PartnerInformationGrp>
          <PartnerId>H</PartnerId>
          <ProgId>H00001</ProgId>
        </PartnerInformationGrp>
        <AmtInformationGrp>
          <HighAmt>1744.00</HighAmt>
          <LowAmt>99.00</LowAmt>
        </AmtInformationGrp>
      </ProgramInfo>

    </ProgramInfoList>
  </GetTestWSResponse>
</response>

is transformed into the result

Code:

<response>
   <GetTestWSResponse>
      <CardNumber>12345</CardNumber>
      <ProgramInfoList>
         <ProgramInfo>
            <PartnerInformationGrp>
               <PartnerId>H</PartnerId>
               <ProgId>H00002</ProgId>
            </PartnerInformationGrp>
            <AmtInformationGrp>
               <HighAmt>19999.00</HighAmt>
               <LowAmt>0.00</LowAmt>
            </AmtInformationGrp>
            <AmtInformationGrp>
               <HighAmt>19.00</HighAmt>
               <LowAmt>12.00</LowAmt>
            </AmtInformationGrp>
         </ProgramInfo>
         <ProgramInfo>
            <PartnerInformationGrp>
               <PartnerId>H</PartnerId>
               <ProgId>H00001</ProgId>
            </PartnerInformationGrp>
            <AmtInformationGrp>
               <HighAmt>24.00</HighAmt>
               <LowAmt>2.00</LowAmt>
            </AmtInformationGrp>
            <AmtInformationGrp>
               <HighAmt>1744.00</HighAmt>
               <LowAmt>99.00</LowAmt>
            </AmtInformationGrp>
         </ProgramInfo>
      </ProgramInfoList>
   </GetTestWSResponse>
</response>

arunprasadlv · May 7th, 2012, 12:48 AM

Thanks Martin . the solution helped a lot.