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
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext 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

 
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
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.