OR statement in a formula

[tpostlewate]

Good afternoon and happy new year! Let's get this party started!
I am trying to figure out how to use an OR statement in a formula.  This is my goal:

If [field 1] OR [field 2] =Y move Y to a new column, otherwise leave blank.

Thanks,
Terri

[pedrodrfaria]

The formula you are looking for should be this:

If [field 1] = "Y" OR [field 2] ="Y" then "Y" else "" endif

Pedro.

[AngelosPachis · Accepted solution]

Hi @tpostlewate ,

In alteryx you have to use an equal sign to each component of the OR statement in a formula tool.

Hope that helps.

Regards,

Angelos

[jrgo · Accepted solution]

IF [Field1] = 'Y' OR [Field2] = 'Y' THEN 'Y' ELSE '' ENDIF

[tpostlewate]

This is my formula:

If [BehaviorBank: Donates to environmental causes] = Y OR [BehaviorBank: Contributes to charities] = Y then "Y" else "" endif

But I get a parse error at char (53): Unknown variable "Y" (Expression #1)

[pedrodrfaria]

Make sure to put the Y inside of quotes if the field is a string value. If is numeric, do not put it inside of quotes.