Filtering for null values

[JBoles]

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

[messi007]

@JBoles,

Could you share the workflow with the expected output.

I will help us to provide a solution.

Regards,

[mceleavey]

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.

[JBoles]

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

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

How do I tweak the formula?

Thanks!

[mceleavey]

Ah, I've got it...

[mceleavey · Accepted solution]

Hi @JBoles ,

the syntax is :

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

[SeanAdams]

@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]

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