ArcGIS has a confusing method for updating field names when combining tables with duplicate field names. For example, I have two tables containing the field
If I run
Id with key field
OBJECTID the new field is
One would suspect that should the process repeat the field would be added with field name
Id_2. However, this is not the case. Instead the field is added as
Repeat the process dozens of times and the field name logic gets more complex.
If a field name length is 64 the count adds one as one would expect.
Question: What is the programmatic logic used to determine field names from geoprocessing when duplicate fields are present?