Boolean Field Combo = Update or Create Field

[tcwildhart]

I believe this is easy, but I can't seem to figure out why I can't get it to work. 

I have a data set with data in bool data type. (Example Below)

Code	C1 Enabled	Manual C1	Q2 Enabled	Manual Q2
ABC	FALSE	FALSE	FALSE	TRUE
DFG	TRUE	FALSE	TRUE	TRUE
BNM	TRUE	TRUE	TRUE	FALSE
ZXC	FALSE	TRUE	FALSE	FALSE

Depending on the value combos... I want the data to come out like the following:

Code	C1 Enabled	Manual C1	Q2 Enabled	Manual Q2	Status1	Status2
ABC	FALSE	FALSE	FALSE	TRUE	No	No
DFG	TRUE	FALSE	TRUE	TRUE	Auto	Manual
BNM	TRUE	TRUE	TRUE	FALSE	Manual	Auto
ZXC	FALSE	TRUE	FALSE	FALSE	No	No

You can see from the data above, there are 3 possible status types given 4 combinations of each type - C1/C1 and C2/C2

The formula below... does update Status1... but I can only get Auto and '0' and the logic doesn't seem to work. 

IF  [C1 Enabled]  &&  [Manual C1]  THEN  [Status1]  =  'No'  ELSE  'Auto'  ENDIF

1. What is wrong with my logic? 

2. Is it possible to have Alteryx create the column for me to enter the data? Or, do I need to provide the field for in which the data will be written given the conditional formula? 

3. How do I get the formula to check for the different conditions and then output the correct one? 

[TonyA · Accepted solution]

What you've shown would return "No" if the two columns were TRUE. Also I don't see anything to account for "Manual". This works for Status1:

IF ![C1 Enabled]
THEN "No"
ELSEIF [Manual C1]
THEN "Manual"
ELSE "Auto"
ENDIF

I've attached a workflow that gives the result you were looking for.

[tcwildhart]

This worked great and helped me with a few other items. Thank you!