topic Re: Failed to open table. Error: An Item with the same key has already been added in ArcGIS Pro Questions

Failed to open table. Error: An Item with the same key has already been added

RyanDaily — Tue, 22 May 2018 15:57:00 GMT

I keep getting this error message when after joining a table with no spatial data to a Shapefile via a common attribute

I'm new to ArcGIS but have been able to do this easily using QGIS recently. I have literally no idea what the message means. This has happened with two separate shp files.

Can someone help please?

Re: Failed to open table. Error: An Item with the same key has already been added

DanPatterson_Retired — Tue, 22 May 2018 16:10:14 GMT

table names? field name for join?

I would suggest that you copy your shapefiles into a file geodatabase first... issues with shapefiles that have been produces/used in QGIS have surfaced recently

Re: Failed to open table. Error: An Item with the same key has already been added

AllanSchori — Wed, 31 Oct 2018 03:45:39 GMT

I recreated the error by joining a table with two field names that were the same. Make sure each of your field names in your table are unique.

Re: Failed to open table. Error: An Item with the same key has already been added

zkovacs — Fri, 09 Nov 2018 10:25:00 GMT

Ryan,

It means that one or more of the fields in the joined table have the same name as a field/fields in the layer you are joining to. I was very surprised to come across this in Pro since ArcMap has no problem with joining them, regardless having the same field names.

Might be worth raising it with Esri's Tech support as a bug/enhancement (after you've checked that the same join works fine in ArcMap.)

I hope this helps,

Zoltan

Re: Failed to open table. Error: An Item with the same key has already been added

DanPatterson_Retired — Sat, 10 Nov 2018 00:15:41 GMT

I think ArcGIS Pro is being a little more forward thinking in ensuring that requirements are being met

For geodatabase fields....

Define fields in tables—Geodatabases | ArcGIS Desktop

Field names in the same table must be unique; for instance, you can't have two columns with the name ObjectID. Field names must also start with a letter and not contain spaces or reserved words. Field names are limited to 64 characters for file geodatabases, 31 characters in SQL Server and SQLExpress, 30 characters in Oracle and DB2; dBASE is limited to 10 characters.

There is loads more information there. The above defines the 'within' table situation. When joining, the field names do become unique... ie a sample of using Join Field for two polygon featureclasses, keeping the geometry information

Re: Failed to open table. Error: An Item with the same key has already been added

zkovacs — Sat, 17 Nov 2018 22:41:08 GMT

Unique field names were always a case when creating new tables/feature classes even in ArcMap. Joins are created with SQL statements and such, the resulting schema is always referred to with fully qualified field names - eg. sourcename.fieldname. Therefore it shouldn't matter if I have the same field name(s) in the table to be joined.

ArcMap is perfectly capable of dealing with this, and if the result is exported the field names are automatically suffixed as '_1', '_2' etc. to ensure the unique field naming. I'd expect the same behaviour in Pro...

Re: Failed to open table. Error: An Item with the same key has already been added

DanPatterson_Retired — Sat, 17 Nov 2018 22:58:04 GMT

Zoltan, my image shows the suffix behaviour… it was done in Pro