4 Replies Latest reply: Jul 23, 2015 12:28 AM by Tresesco B RSS

    FILL WITH PREVIOUS VALUE

      I have this table

       

         

      IDYEARWEEKYEARWEEK|WEEKWEEK
      1201103201103|1313
      2201103201103|1313
      3201103201103|1313
      4201103201103|1313
      5201103201103|1313
      6201103201103|1313
      7201103201103|1414
      8201103201103|1414
      9201103201103|1414
      201103201103|1515
      10201103201103|1616
      11201103201103|1616
      12201103201103|1616
      13201103201103|1616

       

       

      I need fill whit the yelloe lines the blue, when id is null add all previous week values.

       

      Also can be 2 or 3 week to fill. no is a solution previous.

       

      example i will expect for 3 blanks week.

       

         

      IDYEARWEEKYEARWEEK|WEEKWEEK
      1201103201103|1313
      2201103201103|1313
      3201103201103|1313
      4201103201103|1313
      5201103201103|1313
      6201103201103|1313
      7201103201103|1414
      8201103201103|1414
      9201103201103|1414
      7201103201103|1515
      8201103201103|1515
      9201103201103|1515
      7201103201103|1616
      8201103201103|1616
      9201103201103|1616
      10201103201103|1717
      11201103201103|1717
      12201103201103|1717
      13201103201103|17

      17

       

       

       

       

      Thanks! Regards