Maximum Value in Script for different ID

[#1]

Hi all,

I have data like

Table1:

ID	Value
1	53
1	32
1	89
1	45
2	31
2	32
3	59
4	30
4	-39
5	21
5	34
5	46
6	-

I want

Table2:

ID	Value
1	89
2	32
3	59
4	-39
5	46
6	-

How to do this in Script?

Script written :-

Table2:

Load Distinct ID,

          Max(Value) as New_Value

Resident Table1;

But its showing invalid expression on reload.

Any help?

Regards,

Anjali Gupta

[#2]

Thanks Tamil Nagaraj..

[#3]

Thanks Peter for the knowledge..

Regards,

Anjali Gupta

[#4]

Thanks Max for the help.