With XSLT 2.0, you can do as following:
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0">
<xsl:output method="text" />
<xsl:template match="/">
<xsl:value-of
select="distinct-values(//PRODUCT_NUMBER[following-sibling::CUST_MSG[1]
= 'Y'])" separator="," />
</xsl:template>
</xsl:stylesheet>
You could adapt the idea to suit your requirement.
On 3/30/07, Senthilkumaravelan K <skumaravelan(_at_)googlemail(_dot_)com> wrote:
Hi ,
Is there anyway I could select all the unique PRODUCT_NUMBER with
their sibling node CUST_MSG=Y in a for loop so that i can concatenate
comma.if it is more than one .
Please help me this .
Thanks,
Senthil
On 3/29/07, Senthilkumaravelan K <skumaravelan(_at_)googlemail(_dot_)com> wrote:
> Hi
> <LINE_ITEMS>
> <LINE_ITEM>
> <PRODUCT_NUMBER>1</PRODUCT_NUMBER>
> <CUST_MSG>Y</CUST_MSG>
> </LINE_ITEM>
> <LINE_ITEM>
> <PRODUCT_NUMBER>1</PRODUCT_NUMBER>
> <CUST_MSG>Y</CUST_MSG>
> </LINE_ITEM>
> <LINE_ITEM>
> <PRODUCT_NUMBER>1</PRODUCT_NUMBER>
> <CUST_MSG>Y</CUST_MSG>
> </LINE_ITEM>
> <LINE_ITEM>
> <PRODUCT_NUMBER>2</PRODUCT_NUMBER>
> <CUST_MSG>N</CUST_MSG>
> </LINE_ITEM>
> </LINE_ITEMS>
>
> My expected out is
> <products>1 and 2.
> depends on the CUST_MSG value I need to concatenate "," and respectively.
>
> Thanks,
> Senthil
--
Regards,
Mukul Gandhi
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--