Fetching the max value from ROWS in pentaho
<p>I have a table structure </p>

<pre><code>ID  Col_1  col_2  col_3  col_4
1    34     23     45     32
2    20     19     67     18
3    40     10     76     86
</code></pre>

<p>I here want the max value from col_1,col_,col_3,col_4 so my output looks like</p>

<pre><code> ID   Col_1   col_2  col_3  col_4  max
    1    34     23     45     32   45
    2    20     19     67     18   67 
    3    40     10     76     86   86
</code></pre>

<p>any help would be much appreciated.</p>