Start Free Trial

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
8 - Asteroid

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
binu_acs
21 - Polaris

@Khristian_Evans can you elaborate on your requirement?

Khristian_Evans
8 - Asteroid

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

 
 

 

 

 

binu_acs
21 - Polaris

@Khristian_Evans one way of doing this

image.png

Khristian_Evans
8 - Asteroid

this solution isn't returning an output back for me

Khristian_Evans
8 - Asteroid

Hi, this solution didn't work for me 

binu_acs
21 - Polaris

@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
18 - Pollux
18 - Pollux

@Khristian_Evans@binu_acs'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
Top Solution Authors