Skip to main content
Data:

 

1-Excel sheet with two columns ABB and NME (abbreviation and full name)  900+ records.

 

2-Shapefile with Attributes MUNR & MUNL. This attribute has the same abbreviated municipality names as the excel sheet.

 

 

What i'm trying to do is create two new attributes (MUNRFull & MUNLFull) on the shapefile that will have the full names.

 

 

The statement would be something along the lines of

 

where ABB = MUNR give me the NME output as MUNRFull.

 

where ABB = MUNL give me the NME output as MUNLFull.

 

 

 

 
Hi,

 

Based on my understanding of question, I have attached screenshot below...

 


Reply