IN function
Is the SQL IN function not supported by Domo? I've noticed when I attempt to use this, the Beastmode (or ETL function) is saved without error, but it doesn't seem to pull in the results.
i.e. case when 'event_name' in ('page_view','session_start','scroll') then 'Yes' else 'No' end
Best Answer
-
No you cannot. You would have to do: CASE WHEN `session_medium` LIKE('%Email%') OR `session_medium` LIKE('%email%') OR `session_source` LIKE('%Email%') OR `session_source` LIKE('%email%') THEN 'Email' ELSE 'Whatever' END
I would recommend using LOWER() function so you don't have to have both Email and email in your statement.
If I solved your problem, please select "yes" above
2
Answers
-
The IN function is supported and your case statement looks correct. There may be an underlying data issue, capitalization issue, or something else.
If I solved your problem, please select "yes" above
0 -
can you use wildcards in an In statement?
=when
SESSION_MEDIUM
in ('%Email%','%email%') orSESSION_SOURCE
in ('%Email%','%email%') then 'Email'0 -
No you cannot. You would have to do: CASE WHEN `session_medium` LIKE('%Email%') OR `session_medium` LIKE('%email%') OR `session_source` LIKE('%Email%') OR `session_source` LIKE('%email%') THEN 'Email' ELSE 'Whatever' END
I would recommend using LOWER() function so you don't have to have both Email and email in your statement.
If I solved your problem, please select "yes" above
2
Categories
- All Categories
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 283 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 90 SQL DataFlows
- 566 Datasets
- 2K Magic ETL
- 3.4K Visualize
- 2.3K Charting
- 596 Beast Mode
- 13 App Studio
- 29 Variables
- 594 Automate
- 148 Apps
- 417 APIs & Domo Developer
- 28 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 362 Distribute
- 99 Domo Everywhere
- 261 Scheduled Reports
- 2 Software Integrations
- 97 Manage
- 94 Governance & Security
- 14 Product Releases
- Community Forums
- 37 Getting Started
- 28 Community Member Introductions
- 90 Community Announcements
- 4.8K Archive