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 |
Solved! Go to Solution.
@kathbanc
We can use the Contains Function in the Formula tool.
If contains([Name],[Name 2]) then 'Matched' else "Unmatched" endif
I think what @Qiu meant was like this:
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/
@kathbanc
Glad to be any help. 😁