ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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!

MarqueeCrew
19 - Altair
19 - Altair

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.
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
19 - Altair
19 - Altair

sorry.  i fixed the logic 🙂

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Please Subscribe to my youTube channel.
MarqueeCrew
19 - Altair
19 - Altair

yes.  good for 11 and probably all future releases.

Alteryx ACE & Top Community Contributor

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

Thanks a bunch as always!

Labels