Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Where and Multiple Conditions

sriniprad08
11 - Bolide

Hi Team,

hope you are well. I need help.

 

I have a data set and below conditions. can you please help me how to execute the below where clause.?

 

Condition : Where A = 'C' and B ! = C

 

Thanks,

Sri

 

sriniprad08_0-1687168620643.png

 

4 REPLIES 4
BRRLL99
11 - Bolide

Use Formula tool

and try this formula

 

BRRLL99_0-1687169415008.png

 

Raj
14 - Magnetar

if [A]="C" and [B]!=[C] then "Yes" else "No" endif

Raj_0-1687169422427.png

 

sriniprad08
11 - Bolide

Thank you @Raj 

sriniprad08
11 - Bolide

Thank you @BRRLL99 

Labels