Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: How to Get Max from different Column

  1. #1

    Default How to Get Max from different Column

    Hi All, Question please

    I got a data with column a, b, c
    which have value(integer) in it

    1,3,5
    4,9,10
    11,5,8
    2,88,1

    how can i make pentaho to get the max value of these row?

    1,3,5 result 5
    4,9,10 result 10
    11,5,8 result 11
    2,88,1 result 88

    thanks in advance

  2. #2
    Join Date
    Nov 2009
    Posts
    687

    Default

    I would do that with a formula step. MAX([a];[b];[c])

  3. #3

    Default

    it works, thank you johanhammink

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.