5 Replies Latest reply: Mar 11, 2015 6:28 AM by Melissa van Kluyve RSS

    Rank function for non-numeric values

      Hello,

       

      I have a Segment field with values 'H', 'M', 'L'

       

      To sort these, I am not able to use load order, alphabetical, etc. Without adding an INLINE table to the script, is it possible to use tha Rank function to order my segments like H, M, L in my table?

       

      Many thanks

       

      Mel