ETL Option to blank field

Jerone

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?

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`)