Beast Mode Case Excluding Certain Strings
Domomon
Member
in Beast Mode
I'm trying to build a beast mode that outputs a value when one string of text is found and another string is NOT found. How do you do that in Beast mode? See example of what I'm trying to do down below. I included that minus in front of the semi to indicate that I do not want that string of text to be included.
CASE
WHEN `campaign` LIKE '%online%' THEN 'Online'
WHEN `campaign` LIKE '%residential%' AND `ga_campaign` LIKE -'%semi%' THEN 'Residential'
ELSE 'Other'
END
Tagged:
0
Answers
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 303 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 640 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 767 Beast Mode
- 70 App Studio
- 43 Variables
- 715 Automate
- 185 Apps
- 460 APIs & Domo Developer
- 56 Workflows
- 14 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 402 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 134 Manage
- 131 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive