XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XSLT Help and Discussion » Summarize/Distinct
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> + Use of before and after string (3) Sticky Topic
-> - How do I substitute element ty... (1)
-> + How does one add working days ... (4)
-> - Help, I have existing XLT and... (1)
-> + Need help on XSLT issue - (2)
-> + EDI to XML Conversion (7)
-> - XML To JSON Conversion using X... (1)
-> + Formatting Paragraphs to same ... (2)
-> - Grouping of records (1)
-> + Problems with xsd 1.1 (4)
-> + XML to HL7 mapping (3)
-> + XSLT 3 and Iterate (2)
-> + XSL-FO to PDF preview (3)
-> + java.lang.RuntimeException: Er... (2)
-> + Create Acroforms with Stylus X... (2)
-> + How to change XSLT parameter s... (3)
-> + how to change format of the da... (2)
-> + Search "Next 8 Results " doesn... (2)
-> - Support for Git (1)
-> + newbee (8)
-- [1-20] [21-40] [41-60] Next
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Neal WaltersSubject: Summarize/Distinct
Author: Neal Walters
Date: 05 Oct 2006 03:57 PM
I need to do something like a SQL
"select sum(a), count(b) group by providername", and the tools available are Biztalk, Xpath in Biztalk, and XSLT.

I'm thinking maybe an XSLT is the best way, but not sure if it's possible. I looked at other posts about doing a "distinct" in XPath, but they all looked dependent on the data order (which I cannot control, unless I do another XSLT pass to sort it?)

I have attached a very small sample input and desired output.
Our client recently bought 5 enterprise licenses!

Thanks,
Neal Walters


DocumentSummarizeClaimsSampleInput.xml


DocumentSummarizeClaimsSampleOutput.xml
Postnext
James DurningSubject: Summarize/Distinct
Author: James Durning
Date: 05 Oct 2006 05:48 PM
Originally Posted: 05 Oct 2006 05:46 PM
xpath does have both a sum and count method.
For distinct, I recommend a technique called Muenchian Grouping:
http://www.jenitennison.com/xslt/grouping/muenchian.html

eg:
<xsl:key name="claimsByProvider" match="claim" use="providerName" />
...
<xsl:for-each select="claim[count(. | key('claimsByProvider', providerName)[1]) = 1]">
<xsl:copy-of select="providername"/>
<totalAmount>
<xsl:value-of select="sum(key('claimsByProvider', providerName)/totalAmount)"/>
</totalAmount>
<numberClaimsProcessed>
<xsl:value-of select="count(key('claimsByProvider', providerName))"/>
</numberClaimsProcessed>
</xsl:for-each>
Postnext
Ivan PedruzziSubject: Summarize/Distinct
Author: Ivan Pedruzzi
Date: 05 Oct 2006 05:56 PM


XSLT 1.0 is more then sufficient!
See attached solution.


Ivan Pedruzzi
Stylus Studio Team


UnknownSumAndCount.xsl
Postnext
Neal WaltersSubject: Summarize/Distinct
Author: Neal Walters
Date: 12 Oct 2006 01:52 PM
I have changed the scenario slightly, adding multiple lineitem elements to each provider, and I need to count them.

I'm having difficulty getting this line to work:
<numberLineItemsProcessed>
<!-- How to get next line to work -->
<xsl:value-of select="count(claims/claim[providerName=$currentProviderName]/lineitem)"/>
</numberLineItemsProcessed>

Sample & code attached.

Thanks,
Neal






UnknownSummarizeClaimsSampleInput(1).xml
Sample Input

UnknownSumAndCount.xslt
XSLT

Posttop
Neal WaltersSubject: Summarize/Distinct
Author: Neal Walters
Date: 06 Oct 2006 10:41 AM
Wow! Thanks again!!!! And thanks for the link/explanation of Muenchian Grouping!

Neal

   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.