Null value

grace
grace Member
in Magic ETL

Very basic question here, trying to create a calculated column returning "TRUE" if another column has a value and false if not - neither of these are working. I assume my language is not correct here?

Thanks


case when `Intro Call Held Date (Cleaned)`= value then true else false end 

or

case when `Intro Call Held Date (Cleaned)`= null then false else true end 

Best Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓ 
    CASE WHEN `Intro Call Held Date (Cleaned)` IS NULL THEN FALSE ELSE TRUE END

    Null is a special value and requires the IS comparator instead of = when checking to see if a value is null or not.

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

    Thanks Grant! That worked :)

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓ 
    CASE WHEN `Intro Call Held Date (Cleaned)` IS NULL THEN FALSE ELSE TRUE END

    Null is a special value and requires the IS comparator instead of = when checking to see if a value is null or not.

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

    Thanks Grant! That worked :)

  • GrantSmith
    GrantSmith Coach

    @grace Great! I'm glad it worked for you. If you could accept my answer as a solution so others could find it more easily I'd appreciate it.

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

Categories