AnsweredAssumed Answered

Some data is lost when I join an Excel file to a shapefile

Question asked by tlhowey on Dec 30, 2019
Latest reply on Jan 2, 2020 by tlhowey

I have a census tract shapefile and an Excel file in which one of the fields is census tract number (field = Site_Tract). I am trying to join the Excel file to the shapefile using the common census tract number field. I have verified that the two common fields have the same number type (double), number of decimal places, and significant digits. But when I do the join, some of the records are populated with 'null.' What am I doing wrong?

 

 

Outcomes