Identify Multiple Different Matches in Same Column
I'm looking to be able to build cards that compare different products that are tied to different opportunities. The data currently comes in via one column, and if multiple products are on the opportunity, it is comma-deliminated.
I've tried doing via Beast Mode:
CASE WHEN 'Products' LIKE '%Product1%' = 'Product1'
WHEN 'Products' LIKE '%Product2%' = 'Product2'
However if it matches on Product1, that entire Opp is then tied to Product1 and it doesn't seem to check for Product2'. I'm fine if the same opportunity becomes listed multiple times for each product, but it doesn't do that, it just assigns Product1 and forgets about the rest.
Looking for any help.
I would recommend using magic ETL to first split your product column and then Collapse Columns to convert those column values into rows.
The output you would be looking for would look more like this:
If you need to keep this in a beastmode calculation, you will need to write a separate beastmode for each product.
The way the Case statement gets evaluated is that it looks for the first condition that is true and then stops evaluating. So in your example, if Product 1 was listed, then it would never look for any other products.
You would need to write a beastmode for each product.
CASE WHEN `Products` LIKE '%Product1%' then 'Product1' END
CASE WHEN `Products` LIKE '%Product2%' then 'Product2' END
CASE WHEN `Products` LIKE '%Product3%' then 'Product3' END
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 473 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 209 Visualize
- 257 Beast Mode
- 2.1K Charting
- 12 Variables
- 85 Cards, Dashboards, Stories
- 18 Automate
- 355 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 183 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive