Hello Alteryx Community,
I am new to Alteryx and was able to learn and use a lot of its features. There is only simple requirement that I'd like to insert into my workflow and I am not sure how to approach and solve the problem.
What I am trying to ensure in the data prep workflow is to "flag" out any cell values that is not in my desired list. For instance, see the below table.
Variable 1 | Variable 2 | Output |
A | 1 | Okay |
A | 2 | Okay |
A | 3 | Not OKAY |
So in Variable 1: I have A. What I want to control is Variable 2. My condition is that If Variable 1 is A then Variable 2 can only contain 1 and 2. Otherwise, return "Not OKAY"
I'd appreciate any help/tips on how to build this logic in Alteryx.
Thanks
Solved! Go to Solution.
@mbajodah - you could write an if else statment in the formula tool which would go something like:
IF [Variable 1] = 'A' and ([Variable 2] = 1 OR [Variable 2] = 2) THEN 'Okay'
ELSE 'Not Okay'
ENDIF