TopXML Uncategorized library : Count Distinct

Home Page

Add/Edit your code items

Search the code library

Browse for the code library

Uncategorized
Uncategorized
Uncategorized Contents
Superx++ Compiler and Runtime 1.0
XML Viewer
ALL UPPERCASE or all lowercase
Create an N-Column Table from XML node-set
Class Redefinition using Class Interfaces in Superx++
Object Reclassification: Choosing The Right Tool At The Right Time
XML Search Module for DotNetNuke
Ontology Management System
WebBrowser control customization
xframe - xsddoc
Sum(round(.))
A closer look at XML Data Binding, including a product appraisal (Part 1/3)
Read Directory and Create XML File
XMLSapiens - Open Source CMS
70-291 Demo Exam Questions
70-291 Demo Exam Questions
Time Line Calculation - [ Frame level calculation in Visual Basic 6.0 ]
How to bind a nested xml to a repeater control with Container.DataItem?
How to bind a XML to a DataGrid?
How to bind a XML File to a DropDownList?

<< System.XML WCF, WS, SOAP >>

By	John Workman
First Posted	08/08/2003
Times viewed	163

Count Distinct

This post contains attachments
v20030808213017.zip

Summary Use recursion to count distinct rows based on some, but not all of the attributes in the row.

The following code was created to count the number of rows in the recordset based on several of the attributes. Most examples I was able to find compared the whole node, or only one attribute.

To help you understand what I was trying to accomplish, I will describe the output file. The file I had to create was a flat file that had headers and footers. Every time the financial period changed, you had to create a new header and footer. The file must contain one record for each unique combination of business_date, business unit, GL account, and credit/debit.

Now for the problem, the footer record must contain the record count. Check out the snippet below to see how I resolved it.

Additional information
<Export client_id="1039818" created="7/31/2003 4:02:00 PM"> <Source Alias="GLExport"> <Recordset> <row business_date="7/30/2003" account_number="101" bu_name="5555" action="debit" amount="450" period_name="8/2003"/> <row business_date="7/30/2003" account_number="101" bu_name="5555" action="debit" amount="450" period_name="8/2003"/> <row business_date="7/30/2003" account_number="101" bu_name="5555" action="credit" amount="460" period_name="8/2003"/> <row business_date="7/30/2003" account_number="102" bu_name="5555" action="debit" amount="450" period_name="8/2003"/> <row business_date="7/30/2003" account_number="102" bu_name="5555" action="debit" amount="450" period_name="8/2003"/> <row business_date="7/30/2003" account_number="102" bu_name="5555" action="credit" amount="460" period_name="8/2003"/> <row business_date="7/31/2003" account_number="101" bu_name="5555" action="debit" amount="450" period_name="8/2003"/> <row business_date="7/31/2003" account_number="101" bu_name="5555" action="debit" amount="450" period_name="8/2003"/> <row business_date="7/31/2003" account_number="101" bu_name="5555" action="credit" amount="460" period_name="8/2003"/> <row business_date="7/31/2003" account_number="102" bu_name="5555" action="debit" amount="450" period_name="8/2003"/> <row business_date="7/31/2003" account_number="102" bu_name="5555" action="credit" amount="460" period_name="8/2003"/> <row business_date="8/1/2003" account_number="101" bu_name="5555" action="debit" amount="450" period_name="9/2003"/> <row business_date="8/1/2003" account_number="101" bu_name="5555" action="credit" amount="460" period_name="9/2003"/> <row business_date="8/1/2003" account_number="101" bu_name="5555" action="debit" amount="450" period_name="9/2003"/> <row business_date="8/1/2003" account_number="101" bu_name="5555" action="credit" amount="460" period_name="9/2003"/> </Recordset> </Source> </Export>

Further additional information
<?xml version='1.0' ?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" > <xsl:output method='text' omit-xml-declaration='yes' encoding='ASCII' />  <xsl:key name="period_name" match="//Export/Source[@Alias='GLExport'~/Recordset/row" use="@period_name" /> <xsl:template match="/"> <xsl:for-each select="//Export/Source[@Alias='GLExport'~/Recordset/row[generate-id(.)=generate-id(key('period_name',@period_name)[1~)~"> <xsl:variable name="period_name" select="@period_name"/>  <xsl:variable name="GLs" select="//Export/Source[@Alias='GLExport'~/Recordset/row[@period_name=$period_name~"/>  <xsl:variable name="totalGLs" select="count(//Export/Source[@Alias='GLExport'~/Recordset/row[@period_name=$period_name~)"/> <xsl:variable name="reccnt"> <xsl:call-template name="countrecords"> <xsl:with-param name="node" select="$GLs"/> <xsl:with-param name="totalrecords" select="$totalGLs"/> <xsl:with-param name="index" select="1"/> <xsl:with-param name="recordCount" select="$totalGLs"/> </xsl:call-template> </xsl:variable> <xsl:value-of select="$period_name"/> <xsl:value-of select="' - '"/> <xsl:value-of select="$reccnt"/> <xsl:value-of select="' '"/> </xsl:for-each> </xsl:template> <xsl:template name="countrecords"> <xsl:param name="node"/> <xsl:param name="totalrecords"/> <xsl:param name="index"/> <xsl:param name="recordCount"/> <xsl:variable name="business_date"> <xsl:if test="$index <= $totalrecords"> <xsl:value-of select="$node[$index~/@business_date"/> </xsl:if> </xsl:variable> <xsl:variable name="bu_name"> <xsl:if test="$index <= $totalrecords"> <xsl:value-of select="$node[$index~/@bu_name"/> </xsl:if> </xsl:variable> <xsl:variable name="account_number"> <xsl:if test="$index <= $totalrecords"> <xsl:value-of select="$node[$index~/@account_number"/> </xsl:if> </xsl:variable> <xsl:variable name="action"> <xsl:if test="$index <= $totalrecords"> <xsl:value-of select="$node[$index~/@action"/> </xsl:if> </xsl:variable>    <xsl:choose> <xsl:when test="$index > $totalrecords"> <xsl:value-of select="$recordCount"/> </xsl:when> <xsl:when test="$node[position() > $index~[@business_date=$business_date~[@bu_name=$bu_name~[@account_number=$account_number~[@action=$action~"> <xsl:call-template name="countrecords"> <xsl:with-param name="node" select="$node"/> <xsl:with-param name="totalrecords" select="$totalrecords"/> <xsl:with-param name="index" select="$index + 1"/> <xsl:with-param name="recordCount" select="$recordCount - 1"/> </xsl:call-template> </xsl:when> <xsl:otherwise> <xsl:call-template name="countrecords"> <xsl:with-param name="node" select="$node"/> <xsl:with-param name="totalrecords" select="$totalrecords"/> <xsl:with-param name="index" select="$index + 1"/> <xsl:with-param name="recordCount" select="$recordCount"/> </xsl:call-template> </xsl:otherwise> </xsl:choose> </xsl:template> </xsl:stylesheet>

Rate this article on a scale of 1 to 10 (0 votes, average 0)

Your vote :

<< System.XML WCF, WS, SOAP >>


Leave a comment for this article
Your name
Your email (optional)
Your comment
Optional: Upload an attachment
Enter the code shown:



	Recent Jobs An immediate job opportunity as a Biztal Software Developers Needed in Charlotte, Sr. Software Engineer - Analytics Immediate Mainframe openings for Chennai Immediate TANDEM-TAL openings for Chenna View all Jobs (Add yours) View all CV (Add yours)

	answering service help desk support swimming pool contractor conference call water softener Teleconference Host Department NOLIMIT Web Hosting MSN sunglasses

	Partners Dream.In.Code dotNet Slackers dotNet Spider Your HTML Source VisualBuilder.com DevGuru Planet Source Code ZVON.ORG Web Design ASPAlliance XML Pitstop Scripts The Spot 4 SAP Bitshop Web Hosting

Email TopXML