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;
