Case when syntax issues

Hi,
trying to create a new field in my table using case when;
using syntax as described in the docs 3.0;
however, query “case( when: xxx, then: yyy, else: zzz)” fails systematically at “when” instruction;
can’t figure out why…
a lil insight?

1 Like

Hi @sboupda ,
Could you share with us some screenshots of your error?

Hey @Khai_To i’ve found a pattern.
the instruction fails when i’m trying to insert it within another sql request such as

select 
        abc, 
        def, 
        ghi, 
        case(
            when: xxx,
            then: yyy,
           else: zzz
        ),
        jkl
from table

so i’ve elected to create a calculated field where i’ve written the expression literally

case
    when xxx
    then yyy
    else zzz
end

Hi @sboupda , just wondering what is the error? Any screenshot would be appreciated.