case when statement in ETL mode, incomplete data result
Hi,
When i ran case when statement in ETL mode, there's some condition that haven't shown the result in the right place
Below is the same dataset ran in the ETL mode and preview the dataset, my 'Non-paid users' statement didn't shown in the preview nor in my card, tried many times to update....
did anyone met the same situation? thank you in advance..
Lu
Comments
-
I would suggest altering your CASE WHEN by adding in an ELSE clause (after the ...then 'Guest Users' and before END).
Something like
ELSE 'Outlier'
And then you can filter to only view your Outlier values and see what conditions those rows have and as to why they aren't being caught in your CASE WHEN.
Hope that helps,
Valiant**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.1 -
Hi, @user01131 Lu,
Your TRIM() usage looks suspicious. Are you trying to trim leading and trailing spaces? Or lead and trailing double quotes? the TRIM() function defaults to remove leading and trailing spaces. So if that's what you're trying to do, TRIM(`customer`) should do it. If you're trying to remove leading and trailing double quotes, you probably want something like TRIM('"' from `customer`)
But now that I'm looking at it, I can't tell from your image if you're using single quotes or double quotes or some combination. Either way, @Valiant suggests the best method to troubleshoot the problem
Hope that helps.
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
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 754 Beast Mode
- 61 App Studio
- 41 Variables
- 693 Automate
- 178 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive