Skip to content

    • SQL DataFlows

    SQL DataFlows

    SQL formula for blank cells

    Member
    in SQL DataFlows

    I have a table with some cells that are blank. I would like a zero to populate in the cell instead of them being blank. Is there a simple SQL formula someone could share with me to change the blank cell to a 0 number?

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answers

    • Coach
      Answer ✓

      You could do something like this:

      CASE WHEN TRIM(fieldname) = '' THEN 0

      ELSE IFNULL(fieldname,0) END

      This will check to see if it is blank or if it is null (which are two different things) and replace it with 0 if either are true. Otherwise, it will return the existing value.

      **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.
    • Coach
      Answer ✓

      Alternatively you can combine both together and use a coalesce and NULLIF


      COALESCE(NULLIF(TRIM(`fieldname `), ''), 0)

      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**

    Answers

    • Coach
      Answer ✓

      You could do something like this:

      CASE WHEN TRIM(fieldname) = '' THEN 0

      ELSE IFNULL(fieldname,0) END

      This will check to see if it is blank or if it is null (which are two different things) and replace it with 0 if either are true. Otherwise, it will return the existing value.

      **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.
    • Coach
      Answer ✓

      Alternatively you can combine both together and use a coalesce and NULLIF


      COALESCE(NULLIF(TRIM(`fieldname `), ''), 0)

      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Member

      thank you both, that worked

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories