Cast your vote for the official 2025 Inspire Pin! Designs were submitted by fellow Community members and reflect the creativity and passion of Alteryx users across the globe. Vote now!
Free Trial

Alteryx Designer Desktop Discussions

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

Filling in blank rows on an output with a 'n/a'

Sjkitts
7 - Meteor

Hello, 

 

I am currently trying to figure out a formula that will but a 'n/a' in the rows that don't get filled in once the workflow is ran. I looked at a few discussions and tried the below code. It worked but it got rid of the name and put 'false' in there instead of keeping the name? What do I need to put at the end to keep the names there if they come up and have the rest of the blanks read 'n/a'? Thanks!

 

IF (IsEmpty([Product Owner])) THEN "n/a" ELSE 'false' ENDIF

 

Please see the before and after pictures for details. 

 

 

 

 

3 REPLIES 3
IraWatt
17 - Castor
17 - Castor

Hey @Sjkitts,

To put the name in you will need to reference the name column currently your just putting in the string 'false'. I think you want something like this:

IF (IsEmpty([Product Owner])) THEN "n/a" ELSE [Product Owner] ENDIF

 

Sjkitts
7 - Meteor

@IraWatt thank you so much!! Much appreciated!

IraWatt
17 - Castor
17 - Castor

No worries @Sjkitts ! any time :D 

Labels
Top Solution Authors