Reply
Highlighted
Regular Visitor
Posts: 24
Registered: ‎12-04-2018
Accepted Solution

Replace the null value with the previous value

Hi,

 

I want to fill my null values with the previous value in that column. 

Ex- null = 1/11/2018 (This column have Novemver month all days and some values are null so i want to get the previous date value for my null values)

 

Null values.PNG

 


Accepted Solutions
Member
Posts: 101
Registered: ‎08-16-2017

Re: Replace the null value with the previous value

In many cases, the handy Fill Down feature under the Transform tab will do the trick.

 

FillDown.png

 

 

View solution in original post


All Replies
Member
Posts: 101
Registered: ‎08-16-2017

Re: Replace the null value with the previous value

In many cases, the handy Fill Down feature under the Transform tab will do the trick.

 

FillDown.png

 

 

Regular Visitor
Posts: 24
Registered: ‎12-04-2018

Re: Replace the null value with the previous value

Thank You So Much