cancel
Showing results for 
Search instead for 
Did you mean: 

Replace NULL value for DATE type

SOLVED
Highlighted
macabrera
Meteor

Hi, 

 

I have a file like this

 

Date file.jpg

 

And I wold like to replace the NULL values with the previuos Date + 1. So I have something like this

 

2014-07-01    152071662.1

2014-07-02    151898406.3

2014-07-03    151725150.4

 

and so on...

 

Thanks, 

Alteryx Certified Partner
Alteryx Certified Partner

Use the MultiRowFormula for this

 

use IF isnull([Date]) then DateTimeAdd([Row-1:[Date],1,"days") else [Date] end

 

obviously where Date is the column you are updating.

macabrera
Meteor

Thanks....

 

It works, but just for the first NULL record :(

 

Date file.jpg

Alteryx Certified Partner
Alteryx Certified Partner

Ah - in that case you need to make sure you UPDATE the existing Date column, at the minute I imagine you are creating a new column so it doesnt see the previous one using Row-1

macabrera
Meteor

Yes... Thanks... I realize this the next minute i posted the last comment

 

Thanks 

 

:)

I need something similar to the case above. If column "Tax date" is blank, then I need it to return the first of the year (1/1/2017), otherwise keep the existing date. How can I do this?