Alteryx Designer Discussions

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

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

SOLVED

Is Null formula

vsalver
8 - Asteroid

Is this formula correct? if there is null in A it is not replacing with the B value. Please help

 

If IsNull([A]) then [B] else [A] endif

jdunkerley79
16 - Nebula
16 - Nebula

Yes that is a correct formula to replace nulls with B

 

Are you getting an error message? If so can you post a screenshot?

vsalver
8 - Asteroid

No error message, just the desired results are not coming

jdunkerley79
16 - Nebula
16 - Nebula
Could you post your workflow or some sample data to look at?

At a guess if A is a string field you might want IsEmpty if meaning to replace ‘’ as well as NULL.
AshwiniChezhiyan
7 - Meteor

It is possible that you are not getting the desired results as your main column contains whitespaces. Try using Data Cleasing Tool to clear the field off any redundant spaces before inserting the formula.

 

Also, are you input fields String or others? IsNULL works on both string and numbers, so type may not be an factor

vsalver
8 - Asteroid

IsEmpty worked for me, thanks

Labels