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

[Qiu]

@kathbanc 
We can use the Contains Function in the Formula tool.

If contains([Name],[Name 2]) then 'Matched' else "Unmatched" endif

[kathbanc]

Hi @Qiu,

the Orange,Banana result should be matched. Please see attachment . 

[caltang · Accepted solution]

I think what @Qiu meant was like this:

[Qiu · Accepted solution]

@kathbanc I should have tested it first. Sorry.

The arguments in the function Contains were in wrong order.

@caltang 
Thank you for the correction.

[kathbanc]

Hi @Qiu  @caltang Thank you both so much!!!!! 

[caltang]

If the above solved your need, kindly like & mark as accepted solution so that you may help others find the solution more quickly + to close the thread as is. Thanks!

Best regards,
Calvin Tang
https://www.linkedin.com/in/calvintangkw/

[Qiu]

@kathbanc 
Glad to be any help. 😁