create new field from a loaded one qlikview

[hadoopuser]

Hello,

I have an issue to settle.
I have already loaded data, now I want to create  another field according to origin field.

if (origin = "paris" or "London" or berlin or ....) 
then create "origin europe"
else (origin="texas" or "Seattle" or "new York" or "toronto...)
then create "origin america"
else create "origin Asia"
end if

thanks for your help.

[Vegar]

You could solve it by using ApplyMap.

Map:
MAPPING LOAD
A,B
Paris, Europa
London, Europa
Berlin,Europa
Texas, America
Seattle, America
];

YourTable:
Load
*,
ApplyMap('Map', origin, 'Asia') as Region
From Data;