Beast Mode Code

HelenOBrien
HelenOBrien Member
in Magic ETL

I am trying to write the following Beast mode code

If a date field is blank then "CAPA Phase" else it is "Implementation Phase " the following case statement will not work 

 

 

case when `PA_PLAN_DUE_DATE`='' then 'CAPA Phase' else 'Implementation Phase' end

Best Answer

  • Gimli
    Gimli Domo Employee
    Answer ✓

    Hello, 
    In order to call upon NULL values in a beastmode you refer to them using the key word NULL. 

    For example: 

    CASE WHEN `date` IS NULL THEN 'x' ELSE 'y' END


    If this does not fix the issue you are experiencing you can email our great support team at [email protected]. 



    **Say “Thanks" by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Answers

  • HelenOBrien
    HelenOBrien Member

     how do I work with null dates in DOMO (Beast Mode)

     

    I need to say if date is null then x else y 

     

    please help 

  • Gimli
    Gimli Domo Employee
    Answer ✓

    Hello, 
    In order to call upon NULL values in a beastmode you refer to them using the key word NULL. 

    For example: 

    CASE WHEN `date` IS NULL THEN 'x' ELSE 'y' END


    If this does not fix the issue you are experiencing you can email our great support team at [email protected]. 



    **Say “Thanks" by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • kshah008
    kshah008 Contributor

    @HelenOBrien, did ilikenno's reply help you out?

  • HelenOBrien
    HelenOBrien Member

    this is great -bIG tHANKS 

    CASE WHEN `date` IS NULL THEN 'x' ELSE 'y' END

     

  • user03674
    user03674

    I'm trying to add another command in this statement, but it isn't working. does elseif not work?

     

    Case
    When
    `ACTUAL_START_DATE` is null then 'Tracking'
    elseif 'ACTUAL_START_DATE' is not null and `ACTUAL_END_DATE` is null then 'In Process'
    else 'Completed'
    End

  • Valiant
    Valiant Coach 
    Case
    When
    `ACTUAL_START_DATE` is null then 'Tracking'
    WHEN 'ACTUAL_START_DATE' is not null and `ACTUAL_END_DATE` is null then 'In Process'
    else 'Completed'
    End

    Just change elseif to WHEN instead

     

    That should work for you,

    Valiant

Categories