Join Field doesn't work on multiple fields

TheodoreF — Sun, 12 Dec 2021 03:16:12 GMT

I have a Table stored in a Geodatabase. It has 11 or so fields (text, long) containing address information. It has an ID column too.

I also have a polygon shapefile of the property boundaries for these addresses. The shapefile only has an ID column.

I use Join Field to join the Table to the shapefile using the matching ID columns as the join field.

However, joining all the fields from the Table in one go results in error '000852 cannot add field'.

arcpy.management.JoinField(r"D:\Dropbox\Internal Software\Report_WKTs\Ground_WKTs\recover\GroundWKTsites.shp", "Id", r"D:\Tasks_D\GroundRviewer\Ground_R\GR_temp_dump.gdb\Ground_WKT_to_GIS_table", "Join_id", "Address;Client_ref;ClientName;Date;Dev_risk;Ong_risk;Our_ref;Page_order;Postcode;RES_or_COM;Scale")‍‍

But... if I join the 11 fields in 11 seperate Join Field runs, it does work:

import arcpy, time
arcpy.management.JoinField(r"D:\Dropbox\Internal Software\Report_WKTs\Ground_WKTs\recover\GroundWKTsites.shp", "Id", r"D:\Tasks_D\GroundRViewer\Ground_R\GR_temp_dump.gdb\Ground_WKT_to_GIS_table", "Join_id", "Address")
time.sleep(1)
arcpy.management.JoinField(r"D:\Dropbox\Internal Software\Report_WKTs\Ground_WKTs\recover\GroundWKTsites.shp", "Id", r"D:\Tasks_D\GroundRViewer\Ground_R\GR_temp_dump.gdb\Ground_WKT_to_GIS_table", "Join_id", "Postcode")
time.sleep(1)
arcpy.management.JoinField(r"D:\Dropbox\Internal Software\Report_WKTs\Ground_WKTs\recover\GroundWKTsites.shp", "Id", r"D:\Tasks_D\GroundRViewer\Ground_R\GR_temp_dump.gdb\Ground_WKT_to_GIS_table", "Join_id", "Date")
time.sleep(1)
arcpy.management.JoinField(r"D:\Dropbox\Internal Software\Report_WKTs\Ground_WKTs\recover\GroundWKTsites.shp", "Id", r"D:\Tasks_D\GroundRViewer\Ground_R\GR_temp_dump.gdb\Ground_WKT_to_GIS_table", "Join_id", "Our_ref")
time.sleep(1)
arcpy.management.JoinField(r"D:\Dropbox\Internal Software\Report_WKTs\Ground_WKTs\recover\GroundWKTsites.shp", "Id", r"D:\Tasks_D\GroundRViewer\Ground_R\GR_temp_dump.gdb\Ground_WKT_to_GIS_table", "Join_id", "Client_ref")
time.sleep(1)
arcpy.management.JoinField(r"D:\Dropbox\Internal Software\Report_WKTs\Ground_WKTs\recover\GroundWKTsites.shp", "Id", r"D:\Tasks_D\GroundRViewer\Ground_R\GR_temp_dump.gdb\Ground_WKT_to_GIS_table", "Join_id", "ClientName")
time.sleep(1)
arcpy.management.JoinField(r"D:\Dropbox\Internal Software\Report_WKTs\Ground_WKTs\recover\GroundWKTsites.shp", "Id", r"D:\Tasks_D\GroundRViewer\Ground_R\GR_temp_dump.gdb\Ground_WKT_to_GIS_table", "Join_id", "Ong_risk")
time.sleep(1)
arcpy.management.JoinField(r"D:\Dropbox\Internal Software\Report_WKTs\Ground_WKTs\recover\GroundWKTsites.shp", "Id", r"D:\Tasks_D\GroundRViewer\Ground_R\GR_temp_dump.gdb\Ground_WKT_to_GIS_table", "Join_id", "Dev_risk")
time.sleep(1)
arcpy.management.JoinField(r"D:\Dropbox\Internal Software\Report_WKTs\Ground_WKTs\recover\GroundWKTsites.shp", "Id", r"D:\Tasks_D\GroundRViewer\Ground_R\GR_temp_dump.gdb\Ground_WKT_to_GIS_table", "Join_id", "RES_or_COM")
time.sleep(1)
arcpy.management.JoinField(r"D:\Dropbox\Internal Software\Report_WKTs\Ground_WKTs\recover\GroundWKTsites.shp", "Id", r"D:\Tasks_D\GroundRViewer\Ground_R\GR_temp_dump.gdb\Ground_WKT_to_GIS_table", "Join_id", "Page_order")
time.sleep(1)
arcpy.management.JoinField(r"D:\Dropbox\Internal Software\Report_WKTs\Ground_WKTs\recover\GroundWKTsites.shp", "Id", r"D:\Tasks_D\GroundRViewer\Ground_R\GR_temp_dump.gdb\Ground_WKT_to_GIS_table", "Join_id", "Scale")
time.sleep(1)
print("Done")
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Why???

Re: Join Field doesn't work on multiple fields

DanPatterson_Retired — Tue, 25 Sep 2018 13:08:42 GMT

That error shows up for old old versions of ArcMap (10.1 and 10.2).

One of the reasons cited is that the table is in use by another application. but it has little to do directly with the join. perhaps doing it one at a time with the 'sleep' is enough to release any temporary locks on the file(s).

You could try to see what happens if you remove the sleep lines… I suspect it would fail as well

This can happen when a file is in use by another program, the file is read-only, or the disk is full.

Re: Join Field doesn't work on multiple fields

TheodoreF — Tue, 25 Sep 2018 13:22:36 GMT

Hi Dan, thanks.

I'm only using ArcGIS Pro. And writing the code in IDLE, so no ArcMap in operation...

I've seen it mentioned elsewhere about the layer being in use, however, it would error out whether Pro was open or not... hmmm.

And yes, the sleep was put in as a safety measure.

It's all very odd!

Re: Join Field doesn't work on multiple fields

DanPatterson_Retired — Tue, 25 Sep 2018 13:59:07 GMT

Join Field—Data Management toolbox | ArcGIS Desktop

shows the extra fields in a list, not as a semicolon delimited string

topic Re: Join Field doesn't work on multiple fields in ArcGIS Pro Questions

Join Field doesn't work on multiple fields

Re: Join Field doesn't work on multiple fields

Re: Join Field doesn't work on multiple fields

Re: Join Field doesn't work on multiple fields