Evaluating if columns contains "Yes" then tag that row as "Yes" in a new column

[Masond3]

Hey Team, 

Daft question I have 3 columns, i want  check across those 3 columns if any of those columns has "Yes" then in a new column called "Outcome" then populate with value of "issue". 

Input 

Name Match	City Match	Country Match
Yes	No	Yes
No	No	No
-	-	-

Expected outcome 

Name Match	City Match	Country Match	Outcome
Yes	No	Yes	Issue
No	No	No	Not Applicable
-	-	-	Not Applicable

Looking forward to your response

Regards
Masond3

[gawa · Accepted solution]

hi @Masond3 

You can use Formula tool, and create new field "Outcome" with the below expression.

IF "Yes" in ([Name Match], [City Match], [Country Match])

THEN "Issue"

ELSE "Not Applicable"

END IF

[HomesickSurfer]

Hi @Masond3 

@gawa's solution works great!  If it is probable for the data to have additional values, consider using 'Contains'.

Perhaps you may benefit from a detailed 'Outcome' that lists the identified 'Match'(es)?