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

Filtering for null values

JBoles
5 - Atom

I have two spreadsheets. Joined then need to identify null values. Null value need to be called "new to group". Help?

7 REPLIES 7
messi007
15 - Aurora
15 - Aurora

@JBoles,

 

Could you share the workflow with the expected output.

I will help us to provide a solution.

 

Regards,

mceleavey
17 - Castor
17 - Castor

Hi @JBoles ,

 

I assume you mean a null value in a cell in a column?

 

If so, just use a formula tool to do the following:

 

if IsEmpty([Value]) then "New to Group" else [Value] endif

 

That will replace empty cells (you can change to isnull() if you prefer) with "New to Group"

 

M.



Bulien

JBoles
5 - Atom

JBoles_0-1614280487586.pngJBoles_1-1614280566699.png

I am very new to this. I can't seem to correct the error. I am working with this

JBoles_2-1614280769326.png

Null in new municipality would indicate a municipality has been added.

How do I tweak the formula?

Thanks!

 

 

mceleavey
17 - Castor
17 - Castor

Ah, I've got it...



Bulien

mceleavey
17 - Castor
17 - Castor

Hi @JBoles ,

 

the syntax is :

if IsEmpty([old municipality]) then [new municipality] else [old municipality] endif



Bulien

SeanAdams
17 - Castor
17 - Castor

@mceleavey 's answer is the easiest - but the other way you could do this is to split your data into 2 parts using a filter to check for null values.  The filter condition would be 

IsEmpty([old municipality])

 

you can then do whatever processing you need, and then reassemble them into one data set using a Union tool.

 
JBoles
5 - Atom

Thank you - I was able to work it it out with your help. 

Labels