Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
;
LOAD
RecNo() as NPK,
Employee,
Points,
RESIDENT FINAL_POINTS
ORDER BY
Employee,
Points DESC
;
I guess it gives number for none sorted values :
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;
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
;