Restrict values in variable based on another variable

[mbajodah]

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

[AbhilashR · Accepted 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