https://community.esri.com/t5/arcgis-pro-questions/how-to-join-tables-with-different-features/m-p/1144501#M51539 <P><FONT face="helvetica">Where does the&nbsp;<SPAN>HeatingFuel&nbsp;table reside?&nbsp;</SPAN></FONT></P> Wed, 16 Feb 2022 05:13:43 GMT shan_sarkar 2022-02-16T05:13:43Z https://community.esri.com/t5/arcgis-pro-questions/how-to-join-tables-with-different-features/m-p/1144464#M51532 <P>How do I join these two data sets in ArcGIS? I'm trying to join the HeatingFuel table to USCounties by GEOID. I notice the last five digits in the GEOID field are the same, but I need a way to delete the beginning digits in the HeatingFuel table (or add them to the USCounties table).&nbsp;</P> Wed, 16 Feb 2022 03:00:26 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-join-tables-with-different-features/m-p/1144464#M51532 SarahModlin 2022-02-16T03:00:26Z https://community.esri.com/t5/arcgis-pro-questions/how-to-join-tables-with-different-features/m-p/1144474#M51533 <P>Add a text field to your HeatingFuel table. Make it 10 wide (I guess anything more than 5).&nbsp; Calc that field using an arcade expression something like Right($feature.GEOID, 5).&nbsp; This should give you the common ID you need to create the join or relationship class.</P><P>The Right function will return the farthest right 5 characters from the field you enter into it. The downside of this is that it only works 100% if the ID you want to return is always the last 5 characters of the input string. If some of the IDs&nbsp; are varying in length you might need to use a combo of the Find, Left, and Right functions.&nbsp;</P><P>Also, I'm assuming the common IDs are text since they start with 0, and numeric data types hate that.&nbsp;</P> Wed, 16 Feb 2022 03:31:13 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-join-tables-with-different-features/m-p/1144474#M51533 KimberlyGarbade 2022-02-16T03:31:13Z https://community.esri.com/t5/arcgis-pro-questions/how-to-join-tables-with-different-features/m-p/1144482#M51535 <P>Thanks! But now my next problem is the fact that I can't add a text field to HeatingFuel it's read-only. How can I change that so I can add the text field?</P> Wed, 16 Feb 2022 03:57:21 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-join-tables-with-different-features/m-p/1144482#M51535 SarahModlin 2022-02-16T03:57:21Z https://community.esri.com/t5/arcgis-pro-questions/how-to-join-tables-with-different-features/m-p/1144484#M51536 <P>Nevermind my reply! I figured out how to edit my table! Thank you so so much!</P> Wed, 16 Feb 2022 04:11:11 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-join-tables-with-different-features/m-p/1144484#M51536 SarahModlin 2022-02-16T04:11:11Z https://community.esri.com/t5/arcgis-pro-questions/how-to-join-tables-with-different-features/m-p/1144487#M51537 <P>That could be for a few reasons, but in this case I think it's because this is a .csv file. I would export the csv file to a table in a file geodatabase and add the field there. I guess you could also open the .csv file in Excel and add the column and perform the right function there (excel has its own Right function). Then re-add the .csv to your project. Keeping in mind that a .csv cannot be open in one program and edited in another at the same time&nbsp; it will be locked, which could be your problem now&nbsp;&nbsp;</P> Wed, 16 Feb 2022 04:15:18 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-join-tables-with-different-features/m-p/1144487#M51537 KimberlyGarbade 2022-02-16T04:15:18Z https://community.esri.com/t5/arcgis-pro-questions/how-to-join-tables-with-different-features/m-p/1144501#M51539 <P><FONT face="helvetica">Where does the&nbsp;<SPAN>HeatingFuel&nbsp;table reside?&nbsp;</SPAN></FONT></P> Wed, 16 Feb 2022 05:13:43 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-join-tables-with-different-features/m-p/1144501#M51539 shan_sarkar 2022-02-16T05:13:43Z