We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
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