Alteryx designer Discussions

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

Replacing empty fields

Highlighted
7 - Meteor

Hi,


I have a field that is either "TC", "26", or blank.

 

I'm trying to replace all of the blanks with a word so that I can perform a Join on the result.

 

I'm using the formula IIF(ISNULL([procedure]),"Global",[procedure]) but this does not seem to be working. The blank fields continue on as blanks.

 

Is there some other way to do this?

 

Thank you!

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

try:

 

IIF(IsEmpty([Procedure]),"Global",[Procedure])

if that doesn't work....

IIF(IsEmpty(Trim([Procedure])),"Global",[Procedure])

Cheers,

Mark

 

Updated logic (missed an end paren).

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
7 - Meteor

Hi Mark,

 

Thanks for the suggestions!


I'm receiving the error "Wrong number of parameters for the function "ISEMPTY".

Highlighted
7 - Meteor

By the way, is this still a function in 11.0? I should have specified.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

sorry.  i fixed the logic :)

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

yes.  good for 11 and probably all future releases.

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
7 - Meteor

Thanks a bunch as always!

Labels