Adding Custom Field Based on the Available Field

[#1]

I have 2 fields emp_name and salary...I need to add third Field called as Rank which should have data based on the salary of Employees..like

emp_name   salary      rank

Jim              60000        2

Peter            50000       3

Ram             70000       1

Can Anyone Help?

[perumal_41]

use rank function in load statement rank( col1)

[kaushiknsolanki]

Hi,

   Try this way.

load

RowNo() as Rank,

emp_name as E_N,

sum(salary) as Sal

resident Data Group by emp_name order by salary desc;

Regards,

Kaushik Solanki