Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

AND Function does not work

Highlighted
Alteryx Partner

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

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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.

Highlighted
Alteryx Partner

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

Labels