More than one statement to a field

[#1]

I have the following data ( attached ).

I already have the following statement which says anything that begins with 9 should be assigned a region of unrestricted.

if(WildMatch(Sales_Number ,'9*',Region),'unrestricted',Region) as Region_New

What I now want to do as per the expected output in the spreadsheet is to say any region that begins Lon* should be replaced with London.

Please assist with applying the new logic to current one.

[PrashantSangle]

Hi,

You need nested if else

try like

if(wildmatch(Sales_Number,'9*'),'UnRestricted',

if(wildmatch(Region,'Lon*'),'London',

Region))

Regards

[sushil353]

try this:

if(WildMatch(Sales_Number ,'9*',Region),'unrestricted',Region) or if(wildmatch(Region,'Lon*','London',Region) as Region_New

HTH

[#4]

This is missing a bracket I believe (?)