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.

Conditional formatting

Danielson
5 - Atom

Please can someone help me write this in Alteryx? 

 

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

3 REPLIES 3
CathyS_Slalom
9 - Comet

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.

CathyS_Slalom_1-1654551470605.png

 

binuacs
21 - Polaris

@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

 

binuacs_0-1654551565337.png

 

 

 

Qiu
21 - Polaris
21 - Polaris

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

0607-Danielson-1.PNG0607-Danielson-2.PNG

Labels
Top Solution Authors