rename branch name in column

[Bakhtawar]

Hi all 

here i am trying to rename branch name on the map this is what actual data is 

%BRANCH_CODE_Key  Lat       Long

OHL BXHFP	25.3463	55.4209
Fujayr
Neutral Zone
Ras Al Khaymah
CJYFL YAMPU	25.2048	55.2708
Umm Al Qaywayn
NBQFF	24.4539	54.3773

now i want to rename OHL BXHFP into Sharjah and CJYFL YAMPU into Dubai and this NBQFF into Abu Dhabi 

this column is link to another table so i dont want to direct rename into table i want to rename these into map or any other condition may accepted but not directly into table this is what map looks like 

and here i want names which i mentioned 

any solutions

[CheenuSing]

Hi @Bakhtawar 

Have your tried creating an additional column called ActualBranch using the logic

If ( BranchCode = "OHL BXHFP", "Sharjah", if( BranchCode = "CJYFL YAMPU " ,"duabi",

                                                if (BranchCode = "NBQFF" , "Abu Dhabi", BranchCode)

Cheers

CheenuSing

[Bakhtawar]

this shows an error " Can not find name [%BRANCH_CODE_Key]

check image .. i.imgur.com/DTChXeQ.png