Filtering for null values
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have two spreadsheets. Joined then need to identify null values. Null value need to be called "new to group". Help?
Solved! Go to Solution.
- Labels:
- Join
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Could you share the workflow with the expected output.
I will help us to provide a solution.
Regards,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @JBoles ,
the syntax is :
if IsEmpty([old municipality]) then [new municipality] else [old municipality] endif
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you - I was able to work it it out with your help.
