Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

IF Formula with Contains Function

vujennyfer
8 - Asteroid

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. 

 

vujennyfer_0-1620867805296.png

 

3 REPLIES 3
vizAlter
12 - Quasar

Hi @vujennyfer — Try a "Find Replace" tool 

 

vizAlter_0-1620870720240.png

 

Please mark this solved if it helps.

vujennyfer
8 - Asteroid

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

vizAlter
12 - Quasar

@vujennyfer — Great! Thank you!

Labels