Skip to content

    • SQL DataFlows

    SQL DataFlows

    Syntax for null

    Contributor
    edited March 2023 in SQL DataFlows

    Hi all,

    I am trying to create a formula in ETL that deals with the null values in multiple columns. So far, no matter what kind of formula I use, I am unable to get the blanks filled in

    Here is what I am trying right now based off of all of the other posts I have read

    image.png

    Again, nothing is turning up XYX like I would expect. I am still getting blanks in the data when I run this dataflow.

    **I have tried = null, is blank, else 'xyx' and nothing is filling in.

    Any thoughts or suggestions?

    If this helps, feel free to agree, accept or awesome it!

    Tagged:

    Comments

    • Coach

      It sounds like your data might actually not be null but an empty string. Try something like this to handle empty strings and strings with just spaces:

      1. WHEN COALESCE(TRIM(`Building Status`), '') = '' THEN 'XYX'


      coalesce returns the first non-null value in the parameters supplied. This forces null values to be an empty string.

      TRIM strips all whitespace (spaces, newlines) from the start and end of a string. This simplifies the check for string values which are just 1 or more spaces.

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

      Beautiful. Thanks for the help.

      Really awesome btw.

      If this helps, feel free to agree, accept or awesome it!

    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