Filtering data will completely remove blank values
Hi community,
I'm not sure if this is by design or if this is a bug.
Filtering data within a field will completely filter out the blank values as well. It looks like Domo won't recognize the Blanks as a value.
This is an scenario:
FieldA, FieldB
CategoryA,12345
CategoryB,58679
,89658
CategoryD,97865
CategoryY,74935
Filter: FieldA not equal to 'CategoryA'
The output will also remove the blank for FieldA:
FieldA, FieldB
CategoryB,58679
CategoryD,97865
CategoryY,74935
I've noticed this issue while filtering a Pivot table so I decided to apply the filter within the Magic ETL. Both had the same result!
This sould not be happening.
Any ideas?
Comments
-
This is how DOMO has handled filtering with null values for awhile now; I can't remember if it was for New ETL or an update after that. I suggest assigning a value for the NULL values using Value Map or Formula in ETL.
CASE WHEN FieldA IS NULL THEN 'Blank' ELSE FieldA END
This should save the data from being deleted by your filter.
1 -
@Christianjmzc @a10hall This is actually normal behavior for SQL. If you tried it in SQL server or MySQL, you would get the same result because in SQL, nulls don't work with logical operators as you'd expect. This Wikipedia entry explains it pretty well:
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
3 -
Thank you @a10hall, this path is what we ended up following. Although it is a headache when you have hundreds of datasets with hundreds of ETL's.
@RobSomers you are right, it is a normal behavior for SQL. However, I would expect that DOMO would handle this like other BI Tools or at least have documentation, even a small note while creating filters.
Thank you both!
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 293 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive