2 Replies Latest reply: Sep 23, 2016 12:28 AM by Vishal Jada RSS

    Repeat last value for each null value

    Vishal Jada

      Hi Community,

       

      I have the below data set where i only have Value column. What i would like to create is DesiredValue_Column. In other words, i would like to scan the contents of Value column and repeat the same number if Value column is not null. If value column is null then repeat the previous number from Value column until value column is not null.

       

      For example after value =3, it is null there i repeat 3 until value = 6 and then i simply copy the content of 6. Hope this makes sense. Any guidance is appreciated. Thanks.

       

        

      ValueDesiredValue_Column
      11
      22
      33
      3
      3
      66
      77
      7
      7
      1010