topic add join failure and attribute table column limit in Geoprocessing Questions

add join failure and attribute table column limit

ElaineKuo — Thu, 11 Jul 2013 05:26:56 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

DerekGilby — Wed, 17 Jul 2013 16:13:28 GMT

Hey How are ya?

I am not sure where you are scripting in Python or have used Model Builder. You probably already have, but I would try using Model Builder to troubleshoot the add join. Maybe try one join at a time and see.

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

curtvprice — Thu, 18 Jul 2013 02:41:35 GMT

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. j

Hi Elaine.

This is a limitation of the .dbf table format used for shapefile fields. The max number of fields is 255 and the maximum sum of field widths (scale) is 4000. The only way around this is to move your dataset to file geodatabase (or SDE geodatabase) format.

See the Arc 9.3 help article: Geoprocessing considerations for shapefile output