if statement

[raadwiptec]

is it possible to have if condition with 2 values for ex:

if country = france  then 'Europe' ,'french' else 'other'...

europe and french should be 2 diff values.

[t_chetirbok]

you can try this:

Table:

load

if(match(Country, 'france', 'italy', 'spain') ,if(IterNo()=1,Country, 'europe') , 'other') as New_Column

, Country

, Value

while iterno()<=if(match(Country, 'france', 'italy', 'spain'),2,1);

load * inline

[

Country, Value

france, 100

italy, 200

spain, 300

USA, 150

]

;

I'm not sure if it's that you are looking for