Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
can someone please tell me what's wrong with this statement.
If(BRANCH ='DOME' OR 'MAKOLA' OR 'AVENOR' OR 'MUUS','GREATER ACCRA',IF(BRANCH = 'SWEDRU','CENTRAL',IF(BRANCH ='KUMASI','ASHANTI',NULL()))) as Region;
when i select GREATER ACCRA from Region it only shows DOME and not the rest MAKOLA, AVENOR and MUUS.
Thanks
if statement does not work like this
use
if (Match(Branch,'DOME','MAKOLA' ,'AVENOR','MUUS'),'GREATER ACCRA',
if(Branch='SWEDRU','CENTRAL',
IF(BRANCH ='KUMASI','ASHANTI',Null()))) as Region
if statement does not work like this
use
if (Match(Branch,'DOME','MAKOLA' ,'AVENOR','MUUS'),'GREATER ACCRA',
if(Branch='SWEDRU','CENTRAL',
IF(BRANCH ='KUMASI','ASHANTI',Null()))) as Region
IF(wildmatch(BRANCH ,'DOME' , 'MAKOLA' , 'AVENOR' , 'MUUS') , 'GREATER ACCRA',
IF(wildmatch(BRANCH = 'SWEDRU') , 'CENTRAL',
IF(wildmatch(BRANCH ,'KUMASI') , 'ASHANTI',
NULL()))) as Region
Regards,
Nilesh Gangurde
Thanks a lot