Subject: [xsl] Summing Similar XML Elements for Display From: "Pilarski,James" <James.Pilarski@xxxxxxxxx> Date: Fri, 21 Mar 2003 10:42:31 -0600 |
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
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] Re: XSL:key, Philippe Dubreuil | Thread | RE: [xsl] Summing Similar XML Eleme, Michael Kay |
[xsl] Re: XSL:key, Philippe Dubreuil | Date | RE: [xsl] how to insert the *comple, Peter Gibbons-BU |
Month |