Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How to obtain Median Value

  1. #1
    Join Date
    Mar 2007

    Question How to obtain Median Value

    I have rows coming from a table input. The are Grouped By a row type column. Another column is a value column that I would like to get the median value for each group. To do this I either need a MEDIAN aggregate function, or I need to create my own by accessing (somehow) the number of rows in each group and I need the row number in each group or I need to obtain each group as an array. How can I do this. Is there access to the rowset as well as the rows in javascript?
    Bill P

  2. #2
    Join Date
    May 2006


    You don't have access to the rowset. Kettle is a hub-and-spoke model, table output splits the inputs in rows and passes the rows on.

    You can have a look at the groupby step even if the input is already grouped, it has something as "add linenr, in each group".

    Last edited by sboden; 03-14-2007 at 03:17 AM.

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.