Skip to content

    • Magic ETL

    Magic ETL

    IFNULL - Replace Blank with Text

    Member
    in Magic ETL

    I am attempting to use the IFNULL formula to say if the Data Table column "Worksite" is blank, replace the blank with the text "No Worksite Assigned."  I created a valid formula, however, the resulting chart is still blank and does not have the text.

     

    1. IFNULL(`Worksite`,'No Worksite Assigned')

    Capture.PNG

     

    Any thoughts on a formula to get thisto work? Thanks!

     

     

    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 Answer

    • Coach
      Answer ✓

      OK got it try this one then 

       

      1. case when LENGTH(`Worksite`) = 0 then 'No Worksite Assigned' else `Worksite` end
      Domo Arigato!

      **Say 'Thanks' by clicking the thumbs up in the post that helped you.
      **Please mark the post that solves your problem as 'Accepted Solution'

    Answers

    • Coach

      Try this 

       

      1. IFNULL(TRIM(`Worksite`),'No Worksite Assigned')

      There might be empty spaces that make the field be Not Null

      Domo Arigato!

      **Say 'Thanks' by clicking the thumbs up in the post that helped you.
      **Please mark the post that solves your problem as 'Accepted Solution'
    • Member

      Good thought! I applied your formula, but no luck. It still appears blank in the table without the text.  I also double-checked my report source and there are no extra spaces. Any other ideas are welcomed, I am willing to try!

       

       

    • Coach
      Answer ✓

      OK got it try this one then 

       

      1. case when LENGTH(`Worksite`) = 0 then 'No Worksite Assigned' else `Worksite` end
      Domo Arigato!

      **Say 'Thanks' by clicking the thumbs up in the post that helped you.
      **Please mark the post that solves your problem as 'Accepted Solution'
    • Member

      Yes! The case statement worked. Thanks so much!

       

      Capture.PNG

    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