Cart
[Home] [By Thread] [By Date] [Recent Entries]
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@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx> 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
|
