8 Replies Latest reply on Jun 11, 2018 11:30 PM by ambrose chen

    Fill the null with previous value

    ambrose chen

      I got a dataset there were thousands of Pro_id ,here  I just listed 2 kinds of Prod_id.

      Could someone help me to create a new column "Fill_Null", it fill the null values of column "Points" with the previous value. 

       

      Thanks a lot

      Ambrose

       

       

      Date

      Prod_id

      Points

      Fill_Null

      2017/6/23

      A001

       

       

      2017/6/30

      A001

       

       

      2017/7/1

      A001

      2500

      2500

      2017/8/2

      A001

       

      2500

      2017/9/1

      A001

      2000

      2000

      2017/9/8

      A001

       

      2000

      2018/2/1

      A001

      500

      500

      2018/2/2

      A001

       

      500

      2018/2/13

      A001

       

      500

      2017/8/1

      J093

       

       

      2017/9/1

      J093

      5000

      5000

      2017/9/15

      J093

       

      5000

      2017/9/22

      J093

       

      5000

      2017/10/1

      J093

      1000

      1000

      2017/10/6

      J093

       

      1000

      2017/12/1

      J093

      2500

      2500

      2017/12/8

      J093

       

      2500

      2017/12/15

      J093

       

      2500

      2018/3/1

      J093

      1000

      1000

      2018/3/2

      J093

       

      1000

      2018/3/9

      J093

       

      1000