Like SQL - Contains on a field name

kathbanc

Hi Alteryx Community, 

Need your help on this. I tried the IFELSE condition but it has error. Please help me, thank you in advance. 

Sample 

Name	Name 2	Output
Orange	Orange, Banana	matched
Apple	Orange, Apple	matched
Orange	Orange	matched
Orange	Apple	Unmatched

caltang

I think what @Qiu meant was like this:

For kathbanc.yxmd