Count items within a cell
Best Answer
-
CASE WHEN `field` = '[]' THEN 0 ELSE (LENGTH(`field`) - LENGTH(REPLACE(`field`, ',', ''))) + 1
Some string manipulation options to assist.
If it's an empty array list, return 0, otherwise determine the length of the string and subtract the length of the string with the commas removed (count the number of commas). Add one because it's always one more field than the number of commas.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
CASE WHEN `field` = '[]' THEN 0 ELSE (LENGTH(`field`) - LENGTH(REPLACE(`field`, ',', ''))) + 1
Some string manipulation options to assist.
If it's an empty array list, return 0, otherwise determine the length of the string and subtract the length of the string with the commas removed (count the number of commas). Add one because it's always one more field than the number of commas.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 308 Workbench
- 7 Cloud Amplifier
- 10 Federated
- 3.8K Transform
- 660 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 818 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 781 Automate
- 191 Apps
- 483 APIs & Domo Developer
- 84 Workflows
- 23 Code Engine
- 43 AI and Machine Learning
- 22 AI Chat
- 3 AI Projects and Models
- 18 Jupyter Workspaces
- 408 Distribute
- 116 Domo Everywhere
- 281 Scheduled Reports
- 11 Software Integrations
- 146 Manage
- 142 Governance & Security
- 8 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive