Hi,
I'm trying to figure out how to write my original CASE query by using the custom expressions.
My case in SQL is something like this:
case
when persondetail.postcode in ('9300','9310','9320') then 'Aalst'
when persondetail.postcode in ('9470','9472') then 'Denderleeuw'
else 'Already moved out'
end
What i have now already in a custom column is:
case([Persondetail → Postcode] = '9300', "Aalst")
but really can't figure out how to do the same as in my case.