Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Multiple Conditions Not Outputing Correct Data

Chirag_Gandhi07
8 - Asteroid

Hi Everyone,

 

I created a conditional statement where if the Receive Date or the Disposed Date > 0, then under the column "Group", it should output Null. It is working for Disposed Date, but not for Received Date. I have attached screenshots of the workflow, output, and conditional statements. Any help would be greatly appreciated.

 

Best,

Chirag Gandhi

3 REPLIES 3
Chirag_Gandhi07
8 - Asteroid
 
BenMoss
ACE Emeritus
ACE Emeritus

Your statement is not built correctly, it should be...

 

IF [ReceivedDate] > "0" or [DisposedDate] > "0" then NULL else THE REST endif

Chirag_Gandhi07
8 - Asteroid

Thank you. It worked now. Not sure why it wasn't working because I used this same statement in another workflow and it worked perfectly.

Labels
Top Solution Authors