Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
GELÖST

Filtering on Multiple Columns

nancyyu
Meteoroid

Hi! I am attempting to filter on two columns for values that are null.

The below custom filter does not work.

Please help!

 

IsNull([Rehire/Hire Date])
AND
IsNull[Termination Date (IA)]

2 ANTWORTEN 2
Thableaus
17 - Castor
17 - Castor

Hi @nancyyu 

 

Maybe you're missing parenthesis:

 

IsNull([Rehire/Hire Date])
AND
IsNull([Termination Date (IA)])

 

Cheers,

nancyyu
Meteoroid

That worked. Thank you!

Beschriftungen