[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Conditional Merging of the node based child value ma
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>
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|