Please can someone help me write this in Alteryx?
"stage3" = "1" if opps is 3,4,5,6 or 7 else "0"
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.
@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
@Danielson
In this kindly dictionary mapping issue, I would prefer to use Find and Replace with easy maitainable matching table.