7 Replies Latest reply: Jul 5, 2017 4:20 AM by ahmar ansari RSS

    Fill previous value where there is blank

    gaurav gopale

      Hi All

       

      I have the following table

       

       

      CurrencyDateValue
      USD01/01/201756
      USD02/01/2017
      AED01/01/201718
      AED
      02/01/2017
      AED
      03/01/2017
      AED
      04/01/2017

       

       

      I want the following output

      CurrencyDateValue
      USD01/01/201756
      USD02/01/201756
      AED01/01/201718
      AED
      02/01/2017
      18
      AED
      03/01/2017
      18
      AED
      04/01/2017
      18

       

      ie where ever there is null value in the Value field ,i want to put previous value in that field

       

       

       

      can anyone help me

      Thanks in advance