Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: group by for row counting

  1. #1
    Join Date
    May 2007
    Posts
    128

    Default group by for row counting

    I could've sworn that there used to be a row count step, but group by appears to be my only option now. Do these need to be sorted in order to count rows accurately? Seems a waste of resources if so, especially since the logging is counting rows as is.

    TIA

  2. #2
    Join Date
    Jul 2009
    Posts
    13

    Default

    Hi,

    if you only want to count the rows, you can use the "Univariate Statistics" component like in the example on attachment...

    Best regards,

    Alioune
    Attached Images Attached Images  

  3. #3
    Join Date
    Jul 2009
    Posts
    13

    Default

    It's not so clear on the image so you have to choose a column and select true for 'N'. The column name of the output is column(N), so you can rename it as you want with the select values" object...

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.