anil an.kumar wrote:
I have a requirment which should show the xml o/p like below
<instance>
<mezo eazon="001X1A">abc</mezo>
<mezo eazon="001X2A">def</mezo>
<mezo eazon="002X1A">xyz</mezo>
<mezo eazon="002X2A">abc</mezo>
<mezo eazon="003X1A">def</mezo>
<mezo eazon="003X2A">xyz</mezo>
<mezo eazon="004X1A">aaa</mezo>
<mezo eazon="004X2A">bbb</mezo>
<mezo eazon="005X1A">ccc</mezo>
<mezo eazon="005X2A">xyz</mezo>
</instance>
The tag "001X1A" should frame in such a way that,
POINT1 : The number appearing before 'A' should reset after every two
records
POINT2 : The number appearing before 'X' should be same and need to
increment by 1 for every two records.
like 001,001 then 002,002 then 003....
Here is an XSLT 2.0 stylesheet that produces above output:
<xsl:stylesheet
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
version="2.0">
<xsl:output indent="yes"/>
<xsl:template match="/">
<instance>
<xsl:for-each-group select="//C_TAX_REPORTING_NAME"
group-by="(position() - 1) idiv 2">
<mezo eazon="{format-number(current-grouping-key() + 1,
'000')}X1A">
<xsl:value-of select="current-group()[1]"/>
</mezo>
<mezo eazon="{format-number(current-grouping-key() + 1,
'000')}X2A">
<xsl:value-of select="current-group()[2]"/>
</mezo>
</xsl:for-each-group>
</instance>
</xsl:template>
</xsl:stylesheet>
--
Martin Honnen
http://msmvps.com/blogs/martin_honnen/
--~------------------------------------------------------------------
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>
--~--