4 Replies Latest reply: Sep 17, 2014 8:07 AM by Glenn Renwick RSS

    Create variable for ranked position

    Glenn Renwick

      I have the following table:

       

      LOAD * INLINE [

      Name, Value

      A, 10

      B, 5

      C, 3

      D, 4

      E, 4

      F, 5

      G, 7

      ];

       

      I would like to create a variable that returns the name of the 4th in the list when ranked.

       

      It can't be done on load script.

       

      Thanks for your help