4 Replies Latest reply: Mar 17, 2016 4:45 AM by kushal chawda RSS

    Create  a flag column based on NUMBER

    sunil kumar

      HI all ,

      Please help me to create a FLAG column  below table where for each NUMBER to get Last flag as 1 else 0

       

      NUMBERDATESTATUSFLAG
      129/12/2015 :Assigned0
      129/12/2015 :Assigned0
      129/12/2015 :Resolved1
      215/02/2016 :Assigned0
      215/02/2016 :In Progress1
      304/02/2016 :Pending0
      304/02/2016 :Assigned0
      304/02/2016 :In Progress0
      304/02/2016 :Resolved1
      425/02/2016 :Pending0
      425/02/2016 :Assigned0
      425/02/2016 :In Progress0
      425/02/2016 :Resolved1
      526/02/2016 :Assigned0
      526/02/2016 :In Progress1