Hi,
I have several model id: 12310, 12320, 12330. If the suffixes = "10", "20", "30", I define the typemachine accordingly.
type
typemachine
10
car
20
moto
30
bic...
See more...
Hi,
I have several model id: 12310, 12320, 12330. If the suffixes = "10", "20", "30", I define the typemachine accordingly.
type
typemachine
10
car
20
moto
30
bicycle
| eval typemachine=case(type="10", "car", type="20", "moto ", type="30", "bicycle", 1=1, "autre")
However I want to add the exception, if id=56410 or 65210, it must be the "moto".
Can I do it, please?
Thanks