[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Summing Similar XML Elements for Display
Hello, I have the following XML: <?xml version="1.0" encoding="UTF-8"?> <AccountsReceivable> <Payments CompanyCode="01" Payment="50"/> <Payments CompanyCode="02" Payment="100"/> <Payments CompanyCode="03" Payment="3000"/> <Payments CompanyCode="01" Payment="50"/> <Payments CompanyCode="02" Payment="200"/> <Payments CompanyCode="03" Payment="4000"/> <Payments CompanyCode="04" Payment="5"/> <Payments CompanyCode="01" Payment="50"/> </AccountsReceivable> What I need to do is sum all payment values that are associated with the same company code for display. I want the resulting XML to look something like this: <AccountsReceivable> <Payments CompanyCode="01" Payment="150"/> <Payments CompanyCode="02" Payment="300"/> <Payments CompanyCode="03" Payment="7000"/> <Payments CompanyCode="04" Payment="5"/> </AccountsReceivable> Can anyone offer me some suggestions? Thanks, Jim XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|
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
|