Querying using if statement

Comments

2 comments

  • Avatar
    Latimer Luis

    This should work if you nest the IF statements, similar to what you'd need to do in MS Excel: 

    | if(values in ("A","B","C"),"High",if(values in ("D","E","F"),"Medium",if(values in ("G","H","I"),"low", ""))) as Severity

     

    0
    Comment actions Permalink
  • Avatar
    Swapnil Modak

    Thanks Latimer Luis. It is working as expected

    0
    Comment actions Permalink

Please sign in to leave a comment.