Alteryx Designer Discussions

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

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

Is Null formula

Highlighted
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

Highlighted
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?

Highlighted
8 - Asteroid

No error message, just the desired results are not coming

Highlighted
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.
Highlighted
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

Highlighted
8 - Asteroid

IsEmpty worked for me, thanks

Labels