Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Getting aggregated rows with all columns in Pentaho

  1. #1
    Join Date
    Feb 2013
    Posts
    15

    Default Getting aggregated rows with all columns in Pentaho

    Hi ,

    I have a following scenario

    Lets assume I have a structure like this

    ColA | ColB | .......|ColN | ID1 | ID2 | ID3 | Value

    I have to aggregate the "Value" field by grouping IDI and ID2 and I need other columns in the output as below and with " aggregated set of rows"

    ColA | ColB | .......|ColN | Sum(Value)
    it is noted that group by and memory group by steps only pass the columns specified inside those

    Anyway to to accomplish this ?
    Last edited by siby.abin; 11-01-2013 at 06:52 AM.
    Thanks & Regards,
    Siby

  2. #2
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    I would split the stream in 2 and do a Stream Lookup to merge the aggregated columns with the original columns.
    -- Mick --

  3. #3
    Join Date
    Feb 2013
    Posts
    15

    Default

    but in that case I assume , i would get all rows instead of the aggregated set of rows. ?
    Thanks & Regards,
    Siby

  4. #4
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    Oh, in that case, you can do an aggregate set column as:
    Col A - FirstValue
    Col B - FirstValue
    Value - Sum
    -- Mick --

  5. #5
    Join Date
    Feb 2013
    Posts
    15

    Default

    That should work for me ..Thanks Mick !

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.