Having trouble Joining a Table to A Feature Class

Question

Hi,

I am trying to join an excel table that I have imported into my TOC to a layer that represents huts in a refugee camp; however, the join fails every time.

I have attached the data here if anyone wants to take a hack at it. The nonspatial tabular data file is called A5_Data_GIS_2, and the field I want to join is called housecode. The layer is called houses and the matching field is called House_Num.

Many thanks for any insight into why I can't get this to work.

Thanks,
Lyndy

Join_Data.zip

IMG_20190427_160311.jpg

LoriHatfield1_5-1758306748547.png

RichardFairhurst · Answer

how do you join in case the excel file has data for multiple years, so then you have a one to many join?

See my reply to your other post on this subject here.

Joseph_FlavianGomes · Answer

how do you join in case the excel file has data for multiple years, so then you have a one to many join?

ManuelMeidinger · Answer

There is no need to import the table into the TOC. Just rickt click in your shape and click joins. Then pick the option join table to layer and select the required fields and the location of your excel file.

After you joined the tables simply right click on your shapefile and select data - export data.
Then you will end up with the new shapefile and table.

If you try to open the attribute table right after joining and prior to exporting you should usually get an SQL error or something like that.

I had a similar problem a few weeks ago until I figured out that exporting the shapefile will do the trick. However, I do not know why.

Hope this helps. I am not good at explaining 😉