[XSL-LIST Mailing List Archive Home] [By Thread] [By Date]

[xsl] Conditional Merging of the node based child value match


Subject: [xsl] Conditional Merging of the node based child value match
From: Senthilkumaravelan Krishnanatham <senthil@xxxxxxxxx>
Date: Fri, 15 Sep 2006 10:19:09 -0700

Hi All,
I have following xml as my input and I need to group the item number with the corresponding line item number and form the out as mentioned below.
I would like to how to group the nodes based the condition and form the output.
Thanks in advance .


Senthil

Input XML

<ORDER>
	<TAB_CTO>
<ITEM_NUMBER>000010</ITEM_NUMBER>
<CTO_INFO>YYYYY</CTO_INFO>
</TAB_CTO>

	<TAB_CTO>
<ITEM_NUMBER>000010</ITEM_NUMBER>
<CTO_INFO>XXXX</CTO_INFO>
</TAB_CTO>



	<TAB_ITEM>
<ITEM_NUMBER>000020</ITEM_NUMBER>
<PRODUCT_NUMBER>Z06M</PRODUCT_NUMBER>
<PRODUCT_DESCRIPTION>CTO - IBOOK 14.1 800MHZ</PRODUCT_DESCRIPTION>
<QTY>2.000</QTY>
<PRICE>1825.00</PRICE>
<EXT_PRICE>3650.00</EXT_PRICE>
</TAB_ITEM>

	<TAB_ITEM>
<ITEM_NUMBER>000010</ITEM_NUMBER>
<PRODUCT_NUMBER>XXXX</PRODUCT_NUMBER>
<PRODUCT_DESCRIPTION>PRODUCT1</PRODUCT_DESCRIPTION>
<QTY>2.000</QTY>
<PRICE>1825.00</PRICE>
<EXT_PRICE>3650.00</EXT_PRICE>
</TAB_ITEM>

</ORDER>

Expected output

<ORDER>

	<TAB_ITEM>
<ITEM_NUMBER> 000010 </ITEM_NUMBER>
<PRODUCT_NUMBER>Z06M</PRODUCT_NUMBER>
<PRODUCT_DESCRIPTION>CTO - IBOOK 14.1 800MHZ</PRODUCT_DESCRIPTION>
<QTY>2.000</QTY>
<PRICE>1825.00</PRICE>
<EXT_PRICE>3650.00</EXT_PRICE>
<CTOS>
<CTO_INFO>XXXX</CTO_INFO>
<CTO_INFO>YYYY</CTO_INFO>
</CTOS>
</TAB_ITEM>

	<TAB_ITEM>
<ITEM_NUMBER> 000020 </ITEM_NUMBER>
<PRODUCT_NUMBER>XXXX</PRODUCT_NUMBER>
<PRODUCT_DESCRIPTION>PRODUCT1</PRODUCT_DESCRIPTION>
<QTY>2.000</QTY>
<PRICE>1825.00</PRICE>
<EXT_PRICE>3650.00</EXT_PRICE>
</TAB_ITEM>

</ORDER>


Current Thread
Keywords
xml