formula to include values that don't contain string
Is there a way write a formula that includes a field that doesn't contain a certain string? So for example, I'd like to name a value in a column based on other columns where if the event_name contains "Add-To-Cart" and the page_location doesn't contain "shop", then it'll be "Add to Cart from XXX"...
when `EVENT_NAME` like '%Add-To-Cart%' and `EVENT_PARAMS_PAGE_LOCATION` <> '%/shop/%' then 'Add to Cart from XXX'
Best Answer
-
@NathanDorsch It's the correct syntax. Sometimes the syntax highlighting has a few issues highlighting everything correctly depending on the keywords.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
When you want to exclude something that contains a certain string, you need to use NOT LIKE. So your beast mode would look like this:
case when `EVENT_NAME` like '%Add-To-Cart%' and `EVENT_PARAMS_PAGE_LOCATION` not like '%/shop/%' then 'Add to Cart from XXX' end
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
2 -
thanks... I do notice though, the 'like' gets highlighted purple, but not the 'not'.... is that okay?
0 -
@NathanDorsch It's the correct syntax. Sometimes the syntax highlighting has a few issues highlighting everything correctly depending on the keywords.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
The not should be purple. It's hard to tell what's going on with just the small section of code. Could just be a bug and you can see if the beast mode still works and is valid. Also check if all the other syntax is correct and that you're not missing any and's, when's, etc.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 633 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 760 Beast Mode
- 62 App Studio
- 42 Variables
- 699 Automate
- 181 Apps
- 457 APIs & Domo Developer
- 51 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive