Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: distinct count

  1. #1
    Join Date
    Aug 2007
    Posts
    5

    Default distinct count

    I would like to create a Kettle Transformation to load data from a fact table to an aggregate table which contains a distinct count field. I notice that the Group By step can aggregates fields, but it does not have distinct count function. If I could not use Group By step to do discount count, is there any way to get it done?

    Thanks.

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    What do you think count does in group by? ... a hint... distinct something

    Regards,
    Sven

  3. #3
    Join Date
    Aug 2007
    Posts
    5

    Default

    I guess the count in Group By is "count" but not "distint count"

  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    2 groupby's in sequence (or a sort removing duplicates followed by a group by) and you can get the number of different values in a column.

    Regards.
    Sven

  5. #5
    Join Date
    Aug 2007
    Posts
    5

    Default

    Thank you very much for your help. I'll try to use sort before groupby.

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.