Help with expression

[arusanah]

I have a Table Site  as

Site	Region
EMEA	West
EMEA-ND	Midwest
ND	Asia
abc	Europe
gfh	China

My requirement is where site ='EMEA' , it should be assigned to Region US. I tried following result but it doesnt work

load Site ,

if(Site='EMEA * ',Region='US',Region) as Region

resident Site;

please help

[maxgro · Accepted solution]

LOAD Site,

     if(wildmatch(Site,'EMEA*'), 'US', Region) as Region

FROM

[https://community.qlik.com/thread/168040]

(html, codepage is 1252, embedded labels, table is @1);

[stigchel]

Try with

if(left(site,4)='EMEA','US',Region) as Region