Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Bakhtawar
Post Patron
Post Patron

rename branch name in column

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 BXHFP25.346355.4209
Fujayr  
Neutral Zone  
Ras Al Khaymah  
CJYFL YAMPU25.204855.2708
Umm Al Qaywayn  
NBQFF24.453954.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 

 

 

Capture.PNG

 

any solutions

2 REPLIES 2
CheenuSing
Community Champion
Community Champion

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

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

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

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.