Combine columns except when null (i.e., skip null)

Hi there,

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!

Answers

  • Hi @tlammie1806, an option that could get it closer to your desired state is using CONCAT function, to combine data, as well as a RegEx (e.g. /s), to remove any blank/white spaces. Unfortunately, there isn't an equivalent of TEXTJOIN in Domo currently