IF Formula with Contains Function

[vujennyfer]

I am trying to created an updated bucket column to better group my data.

I have matched the 'name' column to the 'term' column to group the data into buckets. However, the name is matching to different terms. I want to create an updated bucket that blankets all the mismatched terms. Something like: IF bucket CONTAINS 'dining' THEN 'dining' END (partitioned by the name)

I'm not sure how to best go about this. I think the formula tool with contains would be best but open to suggestions. 

[vizAlter · Accepted solution]

Hi @vujennyfer — Try a "Find Replace" tool 

Please mark this solved if it helps.

[vujennyfer]

Thank you vizAlter. I ended up going with a different solution using SQL but this does help. 

[vizAlter]

@vujennyfer — Great! Thank you!