Can you use "or" in "when" statements?
I have a dataset were I have to insert strings in case of numbers. example
field1: 1,2,5,6,10: field2:'num','left','pro','con'
I want to insert the values of field 2 in the plase of field1 as
1=num, 2=left, 5 and 6=pro, 10=pro
I have tried with:
CASE When "field1"='5' or "field1"='6' then 'pro' else "field1" END
I have not found a way to insert more then one variable at the time. Can this be solved a easy way, for example by using or?