ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

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

AND Function does not work

ashissanpui
9 - Comet

Hi team,

 

I am trying to use AND formula which is similar to AND function present in MS Excel. Could you guide me how to use the same? I am in dire need.

 

Let me know your best approach to this.

 

Thank You,

Ashis Sanpui

CharlieS
17 - Castor
17 - Castor

In Alteryx expressions: the "AND" ("&&" also works) is an operator and not a formula. Think of it as a "+" for conditions.

 

 

In Excel: AND([A]=1,[B]=1)

 

In Alteryx: [A]=1 AND [B]=1

or ([A]=1 AND [B]=1) if the parenthesis help.

ashissanpui
9 - Comet

Thank you @CharlieS for the solution. It did work for me.

Labels