Rank in Load Script

[#1]

Hi Geeks,

I have been working so long in assigning the rank to one of my column at the modeling level. I have tried the following expression in the straight table and is working perfectly but I want to implement the same in the Backend.

Expression: =aggr(rank(UpTime,4),Hrs,DATE,UpTime,HostName)

please find the below straight table

DATE	Hrs	HostName	UpTime	Rank
27-02-2017	00	A	0.98	2
27-02-2017	00	B	1	1-2
27-02-2017	00	C	1	1-2
27-02-2017	00	D	0.97	3
27-02-2017	01	A	0.98	2-2
27-02-2017	01	B	1	1
27-02-2017	01	C	0.98	2-2
27-02-2017	02	A	0.97	2
27-02-2017	02	B	0.98	1

Kindly help me with the Logic how this can be implemented.

Thanks.

[Anonymous]

hi

Try this expression:

aggr((rank(UpTime,4),Hrs,DATE,UpTime,HostName),0,1)

[sunny_talwar]

So, you would like to see 1-2, and 2-2 as rank from back end scripting also?