Trying to use a case statement with a When/Then clause inside it formula is validated but not workin

Hi I am trying to use a case statement with a When and Then clause inside it. The formula I am putting in is basic and has worked for other tables but not working for the one I am currently working with.
I have tried these formulas:
1.
CASE `SeasonalDescription`
WHEN 'Easter'
THEN 'Spring and Summer'
ELSE 'Other'
END
2.
CASE TRIM(`SEASONALDESCRIPTION`)
WHEN 'Easter'
THEN 'Spring and Summer'
ELSE 'Other'
END
3.
CASE 'Easter' IN (`SEASONALDESCRIPTION`)
THEN 'Spring and Summer'
ELSE 'Other'
END
All 3 of these formulas are giving me only the value 'other' they are not reading the 'easter' value and giving me the then clause of 'Spring and Summer'. Like i have said this formula same way has worked with other tables just not working this time around and it has been validated by beast mode too.
Answers
-
@Utz Are you writing this case statement in a Beast Mode or a dataflow? I've found that the syntax from your first formula works in SQL dataflows, but not in beast modes. In general, case statements work most consistently across different Domo engines using the syntax below:
CASE WHEN `SeasonalDescription` = 'Easter' THEN 'Spring and Summer' ELSE 'Other' END
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 114 SQL DataFlows
- 654 Datasets
- 2.2K Magic ETL
- 4.1K Visualize
- 2.5K Charting
- 803 Beast Mode
- 79 App Studio
- 44 Variables
- 758 Automate
- 188 Apps
- 480 APIs & Domo Developer
- 73 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 408 Distribute
- 119 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
- 114 Community Announcements
- 4.8K Archive