ETL Option to blank field

Jerone
Jerone
in Magic ETL

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?

Answers

  • GrantSmith
    GrantSmith Coach

    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`)
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • MarkSnodgrass
    MarkSnodgrass Coach

    You might also try:

    IFNULL(`company_name`, `group_name`)


    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories