FAQ: Why does the attribute table have Null or empty values after a join?
Why does the attribute table have Null or empty values after a join?
After performing a join between a feature class and a stand-alone table, such as dBASE IV, dBASE V, CSV, or PRN, the values in the fields from the joined table are empty or Null.
Null values can be the result of several factors:
Values in the specified fields for the join do not match. Joins are also case sensitive. For example, 'NEW YORK' will not join with 'New York'. To convert string values to the proper case, please refer to the Technical Article in the Related Information section below.