add join failure and attribute table column limit

ElaineKuo — Thu, 11 Jul 2013 05:28:36 GMT

System: ArcGIS 9.3 and Vista

Hello

I am using the function add join to combine three shape files into one shape file. (by python script)
Each of them has about 650 columns in the attribute table.

However, the add join always failed.
The error message is
Could not load data from the data source
If you can correct the problem, click the refresh button to refresh data.
Possible problems can include bad network connection, invalid field, etc.
An invalid SDE statement was used.
(I am sure nothing to do with invalid field,*
because all the shape files were produced by the add join method. )

I am wondering if the cause was the over-limit column number.
If so, please kindly advise alternative methods to complete the combination.
Thank you.

Elaine

Re: add join failure and attribute table column limit

DuncanHornby — Thu, 11 Jul 2013 10:46:37 GMT

The answer to your question is here. I would also question the wisdom of any dataset with 650 columns...

topic Re: add join failure and attribute table column limit in Python Questions

add join failure and attribute table column limit

Re: add join failure and attribute table column limit