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
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 623 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 690 Automate
- 177 Apps
- 455 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive