Combine columns except when null (i.e., skip null)
Is there a way to combine values in multiple columns except when the value is null? For example:
This is a small example, I need to combine 8 different columns with a separator without ending up with: cat, , , , , orange, .
I'm essentially looking for a DOMO equivalent of TEXTJOIN() in Excel. The values don't always inform each other i.e., the sixth column may not be null while the third column may be null.
Thank you in advance!
- 10.6K All Categories
- 13 Getting Started in the Community
- 30 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 301 Use Cases & Best Practices
- 499 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- 4 Private Company Board