Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello could anyone please help explain how Rank Function in load script editor works.
is it the same as in SQL
Hi Luben,
There is no Rank() function for the script, it's only a function for charts. What would you like to accomplish?
You can use RowNo() for instance to give a number for each row, more rank like.
Jordy
Climber
hello Jordy, thanks for your response.
here is what i am trying to do below i have use RowNo() and autonumber of the Booking number filed to give it a unique number.
the goal is to filter out all bookings with rank 1. The problem i am facing is using this on the load script on 1m plus rows it takes over 40mins to load. is there a better way for me to filter the data to get bookings with the number 2.
Thanks
Hmm.. I'm not sure about this. Because wouldn't this cause to give it an unique number.. so you're left with only one 1 and one 2 right?
Based on what logic should the ranking work? When is it a number 2?
Jordy
Climber