Magic ETL Nested Case Statement
I am trying to create a nested case statement (I 've provided an over simplified one that I've been experimenting with, but I have the same issue):
WHEN `Specific Category`LIKE '%People%' THEN 'People'
WHEN `Specific Category`LIKE '%Unknown%' THEN
WHEN `Platform` LIKE '%Amazon%' THEN 'Amazon Likely Retail'
ELSE 'blah blah'
ELSE 'would be specific cat'
It continued to not acknowledge the nested Case statement and all of the resulting values are either 'People' or 'would be specific cat'
Any ideas what's going on here? I checked and all of the values do exist. TIA
- 10.7K All Categories
- 13 Getting Started in the Community
- 41 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 120 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board