Case when syntax issues

[sboupda (Serge B)]

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?

[Khai_To]

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

[sboupda (Serge B)]

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

[Khai_To]

@sboupda

the instruction fails when i’m trying to insert it within another sql request such as

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