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
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 310 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 113 SQL DataFlows
- 651 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 792 Beast Mode
- 78 App Studio
- 44 Variables
- 754 Automate
- 187 Apps
- 479 APIs & Domo Developer
- 71 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 407 Distribute
- 118 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive