3 Replies Latest reply: Feb 28, 2017 12:42 AM by murli mohan RSS

    Rank of a column in load script

    Anjali Ahlawat

      Hi Experts,

       

      I have a column(let's say Up time) that has values as shown in the screenshot below:

      Doubt.PNG

      I just want to create another column named as Ranks as shown above that has ranks for the values of the Column Uptime .


      I tried showing the Rank properly but it is coming in the pattern shown above.


      I do not want to create Rank column in expression instead I want that in load script.


      Could anyone please help me to create a column as shown below:


      Up Time |  Rank

      .99         |       4

      .98         |       5

      1            |       1

      1            |       2

      1            |       3


      Thanks in advance.