https://community.esri.com/t5/modelbuilder-questions/naming-issue-after-joining-shapefile-and-xls/m-p/1405133#M3974 <P>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.<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="this is my model for joining" style="width: 999px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/99889i09C569FED18F7A4A/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot (74).jpg" alt="Screenshot (74).jpg" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="this is the attribute table of the shapefile being joinedafter the join using model builder" style="width: 999px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/99890iAC0D547CAAC29C2E/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot (75).jpg" alt="Screenshot (75).jpg" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="this is the attribute table after the join using model builder of the exported shapefile" style="width: 999px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/99891i9B61D5A081F50A0B/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot (76).jpg" alt="Screenshot (76).jpg" /></span></P> Wed, 03 Apr 2024 12:39:28 GMT SimonLake 2024-04-03T12:39:28Z https://community.esri.com/t5/modelbuilder-questions/naming-issue-after-joining-shapefile-and-xls/m-p/1405133#M3974 <P>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.<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="this is my model for joining" style="width: 999px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/99889i09C569FED18F7A4A/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot (74).jpg" alt="Screenshot (74).jpg" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="this is the attribute table of the shapefile being joinedafter the join using model builder" style="width: 999px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/99890iAC0D547CAAC29C2E/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot (75).jpg" alt="Screenshot (75).jpg" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="this is the attribute table after the join using model builder of the exported shapefile" style="width: 999px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/99891i9B61D5A081F50A0B/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot (76).jpg" alt="Screenshot (76).jpg" /></span></P> Wed, 03 Apr 2024 12:39:28 GMT https://community.esri.com/t5/modelbuilder-questions/naming-issue-after-joining-shapefile-and-xls/m-p/1405133#M3974 SimonLake 2024-04-03T12:39:28Z https://community.esri.com/t5/modelbuilder-questions/naming-issue-after-joining-shapefile-and-xls/m-p/1405144#M3975 <P>Are you seeing</P><P><A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/environment-settings/qualified-field-names.htm" target="_blank">Maintain fully qualified field names (Environment setting)—ArcGIS Pro | Documentation</A></P><P>which is referenced in</P><P><A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/add-join.htm" target="_blank">Add Join (Data Management)—ArcGIS Pro | Documentation</A></P><P>Check your environment settings in the model or consider&nbsp;</P><P><A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/join-field.htm" target="_blank">Join Field (Data Management)—ArcGIS Pro | Documentation</A></P><P>as an alternative to "add join"</P><P>&nbsp;</P> Wed, 03 Apr 2024 12:52:43 GMT https://community.esri.com/t5/modelbuilder-questions/naming-issue-after-joining-shapefile-and-xls/m-p/1405144#M3975 DanPatterson 2024-04-03T12:52:43Z https://community.esri.com/t5/modelbuilder-questions/naming-issue-after-joining-shapefile-and-xls/m-p/1405175#M3976 <P>i am not sure about the first one. i am still relatively new to this. how would i see this.</P><P>when i look under environments in the add join it says no environments. not sure if this is what you meaning</P> Wed, 03 Apr 2024 13:39:27 GMT https://community.esri.com/t5/modelbuilder-questions/naming-issue-after-joining-shapefile-and-xls/m-p/1405175#M3976 SimonLake 2024-04-03T13:39:27Z https://community.esri.com/t5/modelbuilder-questions/naming-issue-after-joining-shapefile-and-xls/m-p/1405604#M3977 <P>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.</P> Thu, 04 Apr 2024 07:51:07 GMT https://community.esri.com/t5/modelbuilder-questions/naming-issue-after-joining-shapefile-and-xls/m-p/1405604#M3977 SimonLake 2024-04-04T07:51:07Z https://community.esri.com/t5/modelbuilder-questions/naming-issue-after-joining-shapefile-and-xls/m-p/1405619#M3978 <P>as suggested... it gives you better control</P> Thu, 04 Apr 2024 09:23:43 GMT https://community.esri.com/t5/modelbuilder-questions/naming-issue-after-joining-shapefile-and-xls/m-p/1405619#M3978 DanPatterson 2024-04-04T09:23:43Z