ETL Option to blank field

Jerone · 2022-04-28T02:09:52+00:00

There was an error rendering this rich post.

Im trying to get a field that has blank values to get data from another field is there another way of saying this formula?

case when `company_name` = '' then `group_name` else `company_name` END

somehow this is not working any other way of saying blank value in domo?

Find more posts tagged with

Accepted answers

All comments

GrantSmith

NULL represents a missing value. You could try something like this to handle an entire string and null values NULLIF return NULL if the column has the value specified - empty string in this case - and COALESCE returns the first Non NULL value in the parameters supplied. In other words return the company name if it’s populated otherwise return the group name

 COALESCE(NULLIF(`company_name`,''), `group_name`)

MarkSnodgrass

You might also try:

IFNULL(`company_name`, `group_name`)

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of