Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Conditional Statement with multiple conditions

shelbybradley
7 - Meteor

I am trying to write a statement that basically means If x AND y AND z AND e = "Yes", then "True" else "False". 

Capture 3.PNG

 Above is a set of data I am working with. In the Complete Fulfillment column, I want to capture a True or False for if each row in all the columns labeled "fulfilled" are Yes. For example, Week 1 would be a True and Week 2 would be a False.

 

Any suggestions on how to format that statement in Alteryx?

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @shelbybradley 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1645626010548.png

 

Hope this helps : )

 

Hamder83
11 - Bolide

Hi 

If the requirement is all 3 beeing yes, for complete to be Yes.

Could you not just use, 
IF A,B,C = True
THEN
True
ELSE 
False?

Endif?

atcodedog05
22 - Nova
22 - Nova

Hi @Hamder83 

 

No, it doesnt work that way sadly.

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @shelbybradley 

Cheers and have a nice day!

Labels