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

Replacing empty fields

stphnwl
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!

6 REPLIES 6
MarqueeCrew
20 - Arcturus
20 - Arcturus

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 restart. Order shall return.
Please Subscribe to my youTube channel.
stphnwl
7 - Meteor

Hi Mark,

 

Thanks for the suggestions!


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

stphnwl
7 - Meteor

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

MarqueeCrew
20 - Arcturus
20 - Arcturus

sorry.  i fixed the logic :)

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
MarqueeCrew
20 - Arcturus
20 - Arcturus

yes.  good for 11 and probably all future releases.

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
stphnwl
7 - Meteor

Thanks a bunch as always!

Labels