Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Replace NULL value for DATE type

macabrera
7 - 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, 

5 REPLIES 5
chris_love
12 - Quasar

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
7 - Meteor

Thanks....

 

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

 

Date file.jpg

chris_love
12 - Quasar

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
7 - Meteor

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

 

Thanks 

 

:)

jgaytan20
5 - Atom

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?

Labels