Alteryx Designer Desktop Discussions

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

Formula to populate null rows with specific output

Khristian_Evans
7 - Meteor

I want to populate the null rows in a column with a specific value / output - 12/31/9999. Could someone help with how I could do this please? 

7 REPLIES 7
binuacs
20 - Arcturus

@Khristian_Evans can you elaborate on your requirement?

Khristian_Evans
7 - Meteor

I currently have null rows in my output column that I want to change to 12/31/9999 

 
 

 

 

 

binuacs
20 - Arcturus

@Khristian_Evans one way of doing this

image.png

Khristian_Evans
7 - Meteor

this solution isn't returning an output back for me

Khristian_Evans
7 - Meteor

Hi, this solution didn't work for me 

binuacs
20 - Arcturus

@Khristian_Evans @Are you getting any error message or warnings in the result window? Also can you screen shot your formula tool with the data?

alexnajm
17 - Castor
17 - Castor

@Khristian_Evans@binuacs's solution should work as long as the requirements you shared are correct! Make sure your data type is a string as "12/31/9999" will have to be stored as such

Labels