![]() |
![]() | ![]() | ![]() | Altova Mailing List Archives>Archive Index >microsoft.public.xsl Archive Home >Recent entries [Thread Prev] >Thread Next - RE: Problems grouping using keys and the Muenchian Method Problems grouping using keys and the Muenchian MethodTo: NULL Date: 7/6/2004 9:44:00 AM I've got the following XML fragment repeated multiple times:
<SKU_INFO>
<DETAIL_SEQ_NUMBER>11</DETAIL_SEQ_NUMBER>
<SKU_TIE>1</SKU_TIE>
<SKU_NUMBER>223344</SKU_NUMBER>
<SKU_QUANTITY>2</SKU_QUANTITY>
<MFG_PART_NUM>1234A</MFG_PART_NUM>
<ITEM_TYPE_CODE>N</ITEM_TYPE_CODE>
<SKU_DESCRIPTION>SI,MOD</SKU_DESCRIPTION>
<BASE_SKU_FLAG>y</BASE_SKU_FLAG>
</SKU_INFO>
<SKU_INFO>
<DETAIL_SEQ_NUMBER>11</DETAIL_SEQ_NUMBER>
<SKU_TIE>1</SKU_TIE>
<SKU_NUMBER>113344</SKU_NUMBER>
<SKU_QUANTITY>2</SKU_QUANTITY>
<MFG_PART_NUM>1234A</MFG_PART_NUM>
<ITEM_TYPE_CODE>6</ITEM_TYPE_CODE>
<SKU_DESCRIPTION>MOD</SKU_DESCRIPTION>
<BASE_SKU_FLAG />
</SKU_INFO>
<SKU_INFO>.....
I'm attempting to group by the SKU_NUMBER element using keys but have been unable to get this to work. Here's my xslt:
<ROWSET>
<xsl:for-each select="SKU_INFO[count(. | key('sku_num', SKU_NUMBER)[1]) = 1]" >
<ROW>
<xsl:attribute name="num">
<xsl:value-of select="position()"/>
</xsl:attribute>
<ROW>
<HEADER_ID>
<xsl:value-of select="/CustomerOrder/headerID" />
</HEADER_ID>
<DETAIL_SEQ_NUMBER>
<xsl:value-of select="./DETAIL_SEQ_NUMBER" />
</DETAIL_SEQ_NUMBER>
<SKU_TIE>
<xsl:value-of select="./SKU_TIE" />
</SKU_TIE>
<SKU_NUMBER>
<xsl:value-of select="./SKU_NUMBER" />
</SKU_NUMBER>
<SKU_QTY>
<xsl:value-of select="./SKU_QUANTITY" />
</SKU_QTY>
<MFG_PART_NUM>
<xsl:value-of select="./MFG_PART_NUM" />
</MFG_PART_NUM>
<ITEM_TYPE_CODE>
<xsl:value-of select="./ITEM_TYPE_CODE" />
</ITEM_TYPE_CODE>
<SKU_DESCRIPTION>
<xsl:value-of select="./SKU_DESCRIPTION" />
</SKU_DESCRIPTION>
<BASE_SKU_FLAG>
<xsl:choose>
<xsl:when test="./BASE_SKU_FLAG='Y' " >
<xsl:text>1</xsl:text>
</xsl:when>
<xsl:otherwise>
<xsl:text>0</xsl:text>
</xsl:otherwise>
</xsl:choose>
</BASE_SKU_FLAG>
<UPDATE_DATE>
<xsl:value-of select="$updateDate" />
</UPDATE_DATE>
</ROW>
</xsl:for-each>
</ROWSET>
Any help is greatly appreciated, thanks.
MEC6304
| ![]() | ![]() | ![]() |
| Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | Altova Blog | |||||
|
