Joining Tables

[CindyObath]

Hey all.

I'm trying to join some temporal data I have for different South African provinces from 2001 to 2013. whenever I try to join the table to the provincial data, it brings back a warning saying that the number "2" in the 'years' row is an invalid character, and causes the year to be added to each column, instead of the province specific data for each year.

Any solutions?

Thanks,

Cindy Obath

[NidhinKarthikeyan]

Hi Cindy,

There can be a few causes for this warning.
-The name of the shapefile (The shapefile name may begin with a number).
-The name of the table.
-The file name or its path contains space characters, especially with dbf files.
-A field name in one or both files contains an invalid character, such as a slash, space character, parenthesis, and so forth.

Try removing invalid characters, or rename the file or fields causing the problem. Rename the file/field to omit the invalid character(s). After the file/field has been renamed, the table join must be reestablished.


Hope this helps.