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