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:


      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.