Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
How to give a rank on expression without considering any diamensions in straight table?
no affect of diamension on rank function
Plz help me...
Thanks.
Create Rank from script
New:
LOAD * Inline [
City, Place, Name, Score
Mumbai, ddd, Prakash, 56
Pune, hghg, Anand, 56
Pune, rr, Raj, 56
Mumbai, AAA, Vijay, 55
Pune, tty, Akshata, 45
Pune, fffg, Suraj, 44
Pune, rr, Vijaya, 43
Pune, ygfh, Leena, 34
Mumbai, AAA, Pooja, 30
Mumbai ,Vileparle, Anil, 10 ];
Data:
NoConcatenate
LOAD City, Place, Name,
sum(Score) as Score,
autonumber(sum(Score)) as Rank
Resident New
Group by City, Place, Name;
DROP Table New;