Running the Add Join tool in batch mode fails with error 999999 when joining multiple tables or features layers to a single table or feature layer.
上次发布: August 9, 2018ArcGIS for Desktop
漏洞 ID 编号
BUG-000114213
已提交
May 24, 2018
上次修改时间
June 5, 2024
适用范围
ArcGIS for Desktop
找到的版本
10.6
状态
Will Not Be Addressed
开发团队已考虑过该问题或请求,并决定不会解决该问题。 问题的“其他信息”部分可能包含进一步说明。
附加信息
We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support. Note that ArcGIS 10.8.2 is the current release of ArcGIS Desktop and will enter Mature Support in March 2024 (https://support.esri.com/en-us/products/arcmap/life-cycle). There are no plans to release an ArcGIS Desktop 10.9, and we recommend that you migrate to ArcGIS Pro. See Migrate from ArcMap to ArcGIS Pro (https://www.esri.com/en-us/arcgis/products/arcgis-pro/resources/migrate) for more information.
解决办法
- Run the Join Field tool in batch mode using the same parameters mentioned above.- Run a Python script (BatchAddjoin_1.py , attached to the bug) in the ArcPy window in ArcMap to join multiple tables in a workspace to a feature layer in the map using the arcpy.AddJoin_management.Steps:1. Add the shapefile or feature class to the map.2. Copy all of the tables to a single workspace, either a folder or a file geodatabase.3. Edit the script in Python IDLE.4. Within the script, edit the 'arcpy.env.workspace' parameter to point to the workspace of the tables.5. Edit the 'in_layer' parameter to name of the layer added in the map.6. Edit the in_field: Input join field.7. Edit the join_field: Output join field.8. Open the ArcPy window in ArcMap and copy the script into the ArcPy window.9. Run the script within the ArcPy window. The tables are joined to the feature layer in the map.