Conditional formatting

[Danielson]

Please can someone help me write this in Alteryx? 

"stage3" = "1" if opps is 3,4,5,6 or 7 else "0"

[CathyS_Slalom]

Hi @Danielson - you can use the formula tool and from the highlighted field to create a new column. Then write the formula below to assign 1/0 based on the condition.

[binuacs]

@Danielson Not sure I understand your requirement properly , if the stage3 and opps are two fields in your use case then you can write something like below

[Qiu]

@Danielson 
In this kindly dictionary mapping issue, I would prefer to use Find and Replace with easy maitainable matching table.