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

Request help in a formula

Kaushik
7 - Meteor

 

Hello,

 

I would require assistance in building a formula for the below logic

 

a) Hire = 0 and Joiner =1 then Hire =1

b) Hire = 1 and Joiner = 0 then Hire =1

c) Hire = 1 and Joiner = 1 then hire = 1

d) Hire =0 and Joiner = then Hire = 0

 

Thank you.

1 REPLY 1
rahul1011
8 - Asteroid

Use formula tool, select Hire as the output column and use the below:

 

IF [Hire]=0 and [Joiner]=0 then 0 ELSE 1 ENDIF

 

I assumed that both column only have 1's and 0's, let me know if this is not the case.

Labels