Is Null/Empty

• Is Blank: tests for whether a cell has no apparent value, " " may be missed

• Is Null: tests for whether the result returned in a cell is null

• Is Empty: tests for whether a cell has no value

Excel

• Is Blank: =~ISBLANK!~(‹cell›)

• Is Null: =~ISERROR!~(‹cell›)

=ISBLANK(A1)

=ISERROR(A2)

Tableau

~ISNULL!~(‹field›)

ISNULL([Name])

NB. In Tableau, Null and Blank values are treated as equivalent.

Alteryx

• Is Blank: ~ISEMPTY!~(‹field›)

• Is Null: ~ISNULL!~(‹field›)

ISEMPTY([Name])

ISNULL([Salary])

NB. The ISEMPTY() test will also return 'True' for Null values

OrgVue

• Is Blank: node.‹field›.~isblank!~

• Is Null: node.‹field› == ~null!~

node.name.isblank;

node.salary == null;

tSQL

‹field› ~IS NULL!~

SELECT * 
FROM EmployeesData
WHERE FullName IS NULL

Python

~not!~ ‹field›

not name

NB. The above example assumes a variable has been declared for name. For more information, go to General > Variables.