MAx from from two or fields in script

[#1]

Hi All,

I need to get the max values from multiple columns and want to do this in script.

e.g I have having below columns Col1 to Col4. I want to get another column as MaxValue in the script itself. Please advise

Col1	Col2	Col3	Col4	MaxValue
1	3	4	10	10
2	2	22	4	22
2	2	3	32	32

Thanks,

Sijo

[rajeshvaswani77]

Preceding load and then if conditions will do the trick.

regards,

Rajesh Vaswani

[alexandros17 · Accepted solution]

Here it is an example

[julian_rodriguez]

Hello Sijo

Try this:

MyData:

LOAD

     Col1,

     Col2,

     Col3,

     Col4,

     RangeMax(Col1, Col2, Col3, Col4) AS MaxValue

FROM

MyData.xls

[#5]

Thanks

[#6]

Thanks Rajesh

[#7]

thnaks