Like / Contains operator in Tableau

Contains (Like) operator in Tableau

SInce there is no like operator in Tableau it provides CONTAINS operator. 
Little different syntax is there but not too complex.


Syntax for contains is: 

Below is the example for using CONTAINS operator in a calculated field in Tableau.


IF (CONTAINS([campaign_name],"Intent")) OR (CONTAINS([campaign_name_derived],"Intent")) THEN "Yes"  
ELSE "No" END