The Join Field tool is very useful, but it is very very slow. Please enhance this tool to work faster.
Thanks for this! Lets hope Esri gets around to fixing it.
Link for the lazy: http://www.arcgis.com/home/item.html?id=da1540fb59d84b7cb02627856f65a98d
We also found it working 25 times slower dan in ArcInfo Workstation JoinItem. Here is a python work around: arcpy.MakeTableView_management(strInputdata1, "tableview1")
arcpy.AddJoin_management("tableview1", <joinfield1>, "tableview2", <joinfield2>)
arcpy.TableToTable_conversion("tableview1, <outputworkspace.gdb> , <outputbasename>)
In case of a featureclass use in stead of maketableview, MakeFeatureLayer, and FeatureclassToFeatureclass to export.
For some pythonic ways to handle joining data faster, see the below link.
Yeah, a few years back I recall working with this tool and being floored at how much the performance sucked. Its way too slow. Thankfully da.searchcursors and updatecursors came out shortly afterwards. Now with pandas being included, it could probably be refactored to be about 1,000 times faster.
In ArcGIS Pro 2.2 Join Field was rewritten and is now magnitudes faster in current releases of Pro compared to previous releases, as well as ArcMap.
In which version of ArcMap was it updated?
Hi Curtis. The tool was rewritten for ArcGIS Pro. I understand that given the time that you submitted the idea, it was probably a request related to ArcMap. There are no plans to implement this functionality in ArcMap.
As we review Ideas, whether long-standing or new, and consider what is feasible for incorporation into the software, Ideas will generally be implemented in ArcGIS Pro. ArcGIS Pro is the focus for new development efforts as it is the future of the ArcGIS Desktop product.
Customer feedback continues to be a key driver of ArcGIS Pro software development. Therefore, we encourage you to continue commenting and posting your ideas as this helps us to build ArcGIS Pro to meet your needs and requirements.
You said "as well as ArcMap" which is why I thought it had been done. Obviously I misunderstood your meaning. I am disappointed!
ArcMap is not going away any time soon so it sure would be great if this tool update could be migrated back to ArcMap (as havemany other tools and tool performance enhancements like multiprocessing support).
Looking back I can see that the wording could have been better. Sorry for that - and yes, I hate to disappoint.
You're right that ArcMap will be around for a number of years - it's just that there really isn't any more development going into it. Wish I had a better answer, but I think that is where we are on this one.
I still have a working instance of Workstation. Never give up, never surrender.
Retrieving data ...