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?
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.