SOLVED
IF Formula with Contains Function
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
vujennyfer
8 - Asteroid
‎05-12-2021
06:07 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
Labels:
3 REPLIES 3
vizAlter
12 - Quasar
‎05-12-2021
06:52 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎05-24-2021
11:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you vizAlter. I ended up going with a different solution using SQL but this does help.
vizAlter
12 - Quasar
‎05-24-2021
12:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@vujennyfer — Great! Thank you!
