CASE WHEN using IN
I am trying to filter my records by specific accounts. I am using beat mode to try and do the following:
CASE WHEN `Company Name` IN('COGNIZANT', 'AARP') THEN 1 ELSE 0 END
Then I use this as a filter set to 1 hoping to only return the accounts I am looking for.
When I run this I never get any accounts returned.
Any input would be greatly appreciated
Comments
-
Are there any inconsistencies in the names that you're aware? (Is it possible you have leading or trailing spaces?)
The other thing you could try would be this:
CASE WHEN `Company Name` LIKE '%COGNIZANT%'
OR `Company Name` LIKE '%AARP%'
THEN 1
ELSE 0
ENDHope this helps,
ValiantSpur
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0 -
I am not sure what is going on but I keep getting validation error. I have a list of about 2000 accounts that I am trying to query for. Maybe this isn;t the best way to go about it.
What I am trying to do is match Company Name from my file to Compnay Name in the data and return fields limiting the data to those accounts.
Is CASE WHEN the right way to about this.
0
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 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
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive