0 Replies Latest reply: Apr 16, 2018 12:10 PM by gireeesh e Branched to a new discussion. RSS

    Find Rank using Firstsortedvalue

    gireeesh e

      Hi Hello,

       

      I have a data like this:

      IDID NAMELAYERPERIODR STATUS
      1216AAPP01-01-2017-30-12-2017COMP
      1216BAPP01-01-2017-30-12-2017PEND
      1216CDB01-01-2017-30-12-2017SCOPE
      1216DOS01-01-2017-30-12-2017NOTAVBLE
      1217AAPP01-01-2017-30-12-2017NOTAVBLE
      1217CAPP01-01-2017-30-12-2017PEND
      1217DDB01-01-2017-30-12-2017COMP

       

      If one ID has more then one R STATUS ,then we need to calculate rank based on below table.

       

      R STATUS, RANK:

      COMP,1

      PEND,2

      SCOPE,3

      NOTAVBLE,4

       

       

      RESULTS:

       

      IDID NAMELAYERPERIODR STATUS
      1216AAPP01-01-2017-30-12-2017COMP
      1216CDB01-01-2017-30-12-2017SCOPE
      1216DOS01-01-2017-30-12-2017NOTAVBLE
      1217CAPP01-01-2017-30-12-2017PEND
      1217DDB01-01-2017-30-12-2017COMP

       

      Thanks,

      Gireesh