naming issue after joining shapefile and xls.

[SimonLake]

hi there. so i have this shapefile with polygons for my country. there is a column called sub_cat with values 1 - 5838. I also have a xls. file with information regarding these sub_cat. both files have the column sub_cat with same amount values. when i try joining these together normally it works perfect and when I export the data I can see every column with original names. however i have tried doing this in model builder and when I open the exported shapefile after the join i see all the added columns but they have names corresponding to the file name. see attached photo showing this. i have tried adding the a csv file and dbf file neither work. I have this in arcmap and now in Pro. is there any way to fix this problem.this is my model for joiningthis is the attribute table of the shapefile being joinedafter the join using model builderthis is the attribute table after the join using model builder of the exported shapefile

[DanPatterson · Accepted solution]

Are you seeing

Maintain fully qualified field names (Environment setting)—ArcGIS Pro | Documentation

which is referenced in

Add Join (Data Management)—ArcGIS Pro | Documentation

Check your environment settings in the model or consider 

Join Field (Data Management)—ArcGIS Pro | Documentation

as an alternative to "add join"

[SimonLake]

i think i figured it out. I used the join field tool instead but specified the transfer method to 'use field mapping'. this seems to have worked perfectly.

[DanPatterson]

as suggested... it gives you better control

[SimonLake]

i am not sure about the first one. i am still relatively new to this. how would i see this.

when i look under environments in the add join it says no environments. not sure if this is what you meaning