Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Filtering rows on criteria

  1. #1
    Join Date
    Oct 2007
    Posts
    25

    Default Filtering rows on criteria

    Having the following stream values:

    RowID OtherCol Value GroupByID
    1 aaa 22 5
    2 bbb 33 5
    3 ccc 15 9
    4 ddd 19 9

    How can I get the rows grouped by GroupByID, where Max(Value)?
    In this case I would get:
    - complete row 2 because the max Value for GroupByID 5 is 33.
    - complete row 4 because the max Value for GroupByID 9 is 19.


    Thanks in advance.
    Gustavo

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

    Default

    Out of the head... group using maximum on value over group by in a new filed max... filter rows on "max = value"

    Regards,
    Sven

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.