Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: count unique rows

  1. #1
    Join Date
    Mar 2010
    Posts
    25

    Default count unique rows

    What's the best step to count sorted duplicate rows ?.


    It's "Count duplicate rows". Apologise for the confusion, about, what the heading states.
    Last edited by matvrix; 11-07-2011 at 10:34 AM. Reason: bad heading

  2. #2
    Join Date
    Jun 2007
    Posts
    260

    Default

    Try this with SQL, if the data is coming from a database.
    SELECT country, count(cities)
    FROM countries
    GROUP BY country;

  3. #3
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    The "unique rows" or the "Group by" steps both can give you the number of occurrences.

  4. #4
    Join Date
    Mar 2010
    Posts
    25

    Default

    "Group By" step has helped to resolve this.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.