In ArcMap, I use Add Joins to join a table from a shapefile to another shapefile, based on a field that is used for joining them.
In the output table, the names of the columns have the format tablename.fieldname. I would like to only retain the fieldname as the variable name.
To do so, in Environment Settings -> General Setting, I uncheck "Maintain fully qualified name".
The Join works perfectly, however it has no impact on the output, the variable names are still in the format tablename.fieldname.
There are no common field names in the two tables used for the join (only FID, which cannot be deleted).
How to solve this problem?
Thank you so much,