cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cham Regular Visitor
Regular Visitor

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
AlexisOlson Member
Member

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

 

 

2 REPLIES 2
AlexisOlson Member
Member

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

 

 

Highlighted
cham Regular Visitor
Regular Visitor

Re: Replace the null value with the previous value

Thank You So Much