Select MAX value from multiple fields in a record using SORT
Posted: Fri May 23, 2008 4:41 am
Hi,
I have 30 fields in a record Each field can have number ranging from 001 to 100.
The 30 fields are divided into 3 categories like first 10 fields are in A group, Second 10 are in B group, Third 10 fields are in C group.
I have to identify the max value of these 30 fields and the group associated to this max value
So my out put will have 30 fields and Max Value of 30 fields(000 to 100) and Group(ONE LETTER OR NUMBER LIKE A,B,C OR 1,2,3)
I request help to find the simplest way to do by sort technique.
I have around 3 lakh records in the input file which needs to identify max value and the group done for all the records
KIndly let me know if more information is required
thanks
Venkata Perumala
I have 30 fields in a record Each field can have number ranging from 001 to 100.
The 30 fields are divided into 3 categories like first 10 fields are in A group, Second 10 are in B group, Third 10 fields are in C group.
I have to identify the max value of these 30 fields and the group associated to this max value
So my out put will have 30 fields and Max Value of 30 fields(000 to 100) and Group(ONE LETTER OR NUMBER LIKE A,B,C OR 1,2,3)
I request help to find the simplest way to do by sort technique.
I have around 3 lakh records in the input file which needs to identify max value and the group done for all the records
KIndly let me know if more information is required
thanks
Venkata Perumala