Adding place numbers in scrip

[sculptorlv]

Hello!

I have the following code:

SORTED_MANAGERS:

     LOAD

          Employee,

          Points,

     RESIDENT FINAL_POINTS

     ORDER BY

            Employee,

            Points DESC

;

How can I modify this LOAD statement in order to get an extra column NPK with number 1,2,3 and so forth for Employees with better Points result?

NPK          Employee          Points

1               Janis                    54

2               Jonh                     47

3               Sara                     34

.....

Thank you in advance!

[sasiparupudi1]

  LOAD

RecNo() as NPK,

          Employee,

          Points,

     RESIDENT FINAL_POINTS

     ORDER BY

            Employee,

            Points DESC

;

[sculptorlv]

I guess it gives number for none sorted values :

[stigchel]

Something like this?

FINAL_POINTS:

Load * Inline [Employee,Points

Jonh,47

Sara,64

Janis,54

];

SORTED_MANAGERS:

Load Rowno() as NPK,*;

     LOAD

          Employee,

          Points

     RESIDENT FINAL_POINTS

     ORDER BY Points DESC

;

DROP Table FINAL_POINTS;

[sculptorlv · Accepted solution]

I needed to change the sequence of Ordered columns.

Thank you for help!!

LOAD

RecNo() as NPK,

          Employee,

          Points,

     RESIDENT FINAL_POINTS

     ORDER BY

          Points DESC,           

          Employee

;