New nested statement
I Need to create this nested statement in the Domo Dataflow but I keep getting a syntax error.
I tried doing it a few ways and both are creating errors
SELECT
CASE
WHEN "Status__c" in ('Booked') AND > 111 THEN 'TIER 4'
ELSE 'TIER 1'
END
FROM "sfdc_travel_raw"
or this query
SELECT *,
SUM(case WHEN "Status__c" = 'Booked' > 111 then 'tier 4' else 'tier 1 end)
FROM "sfdc_travel_raw"
Comments
-
@kodonnellLT What field is supposed to be greater than 111? You are missing that field, so it should be:
case when `Status_c` = 'Booked' and `Field` > 111 then 'Tier 4' else 'Tier 1' end
Your last example won't work because you're doing an aggregation without any grouping.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
1 -
@kodonnellLT Both of these queries are returning syntax errors because you need to specify which field needs to be greater than 111 in your case statement. In other words, it should look something like this:
CASE WHEN "Status_c" in ('Booked') and "FieldName" > 111 then 'TIER 4' ELSE 'TIER 1' END
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 99 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 727 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive