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
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
IF [Field1] = 'Y' OR [Field2] = 'Y' THEN 'Y' ELSE '' ENDIF
The formula you are looking for should be this:
If [field 1] = "Y" OR [field 2] ="Y" then "Y" else "" endif
Pedro.
This is my formula:If [BehaviorBank: Donates to environmental causes] = Y OR [BehaviorBank: Contributes to charities] = Y then "Y" else "" endifBut I get a parse error at char (53): Unknown variable "Y" (Expression #1)
