Multiple AND's in an IF Statement

If these values A1, B1, C1 and so on are equal to their counterparts A2, B2, C2 and so on, I want to output "TRUE" in the new To Be Removed column. So I have a formula that looks like this (please note I have changed the variable names to A1, A2 for simplicity).

I have no idea how to format this if statement to work the way I want it.

Help

Accepted answers

binu_acs

@shaheer Your formula should work

Multiple_Condition_1208.yxmd

All comments

PanPP

Hi @shaheer

Try the following expression below:

If [A1] = [A2] then "True" elseif [B1] = [B2] then "True" elseif [C1] = [C2] then "True" elseif [D1] = [D2] then "True" elseif [E1] = [E2] then "True" else "False" endif

Hope this helps, if it does please like this post and if it helps resolve your problem, mark it as a solution. If you have any other questions, please let us know.

binu_acs

@shaheer Your formula should work

Multiple_Condition_1208.yxmd

shaheer

When I try the formula, I get invalid operator error.

binu_acs

@shaheer Can you check the data type of the fields you are using in this formula? all should be the same data type

shaheer

I just checked and it turns out A1, A2, E1, E2 are Booleans. I assumed Alteryx would count them as strings since their values say either TRUE or FALSE. How can I modify the formula?

binu_acs

@shaheer Boolean and Strings are different data types. you need to convert them into strings then try again with your formula. One way of changing alll in to string type is with the Multi-Field formula

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335