7 Replies Latest reply: Apr 4, 2016 10:20 PM by Saran De RSS

    How to fetch previous not null value for a field that contains nulls

    Light Section

      Sample Data Model:

       

      Date

      Col 1Col 2Value
      10/03/2015XYZ1M#NA
      10/04/2015XYZ2M40
      12/04/2015XYZ3M50
      11/04/2015XYZ

      2M

      #NA

       

      How to replace '#NA' with the previous value for rows with same values in Col 1 and Col 2.