topic Joining tables in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/joining-tables/m-p/744970#M339 <HTML><HEAD></HEAD><BODY><P>I have an Excel Spreadsheet that is being updated daily and would like to map that spreadsheet to a feature class. The spreadsheet has an ID field in it (#09-09, etc.) . . . but can I create an ID field in the Feature Class table to Join with or will the data types prevent me from doing that?</P></BODY></HTML> Thu, 12 Jul 2018 21:18:26 GMT SLouq 2018-07-12T21:18:26Z Joining tables https://community.esri.com/t5/geodatabase-questions/joining-tables/m-p/744970#M339 <HTML><HEAD></HEAD><BODY><P>I have an Excel Spreadsheet that is being updated daily and would like to map that spreadsheet to a feature class. The spreadsheet has an ID field in it (#09-09, etc.) . . . but can I create an ID field in the Feature Class table to Join with or will the data types prevent me from doing that?</P></BODY></HTML> Thu, 12 Jul 2018 21:18:26 GMT https://community.esri.com/t5/geodatabase-questions/joining-tables/m-p/744970#M339 SLouq 2018-07-12T21:18:26Z Re: Joining tables https://community.esri.com/t5/geodatabase-questions/joining-tables/m-p/744971#M340 <HTML><HEAD></HEAD><BODY><P>You can add a field to your table to match and in Pro, there is even a field calculator autoincrement ..</P><P>You can even snag the field calculator code here.</P><P></P><P><A class="link-titled" href="http://pro.arcgis.com/en/pro-app/tool-reference/data-management/calculate-field-examples.htm" title="http://pro.arcgis.com/en/pro-app/tool-reference/data-management/calculate-field-examples.htm">Calculate Field Python examples—Data Management toolbox | ArcGIS Desktop</A>&nbsp;</P><P></P><P>in the ...</P><P></P><P>Accumulative and sequential calculations</P><P></P><P>section</P></BODY></HTML> Thu, 12 Jul 2018 21:32:36 GMT https://community.esri.com/t5/geodatabase-questions/joining-tables/m-p/744971#M340 DanPatterson_Retired 2018-07-12T21:32:36Z Re: Joining tables https://community.esri.com/t5/geodatabase-questions/joining-tables/m-p/744972#M341 <HTML><HEAD></HEAD><BODY><P>Will this work in ArcMap 10.2</P></BODY></HTML> Fri, 13 Jul 2018 13:55:50 GMT https://community.esri.com/t5/geodatabase-questions/joining-tables/m-p/744972#M341 SLouq 2018-07-13T13:55:50Z Re: Joining tables https://community.esri.com/t5/geodatabase-questions/joining-tables/m-p/744973#M342 <HTML><HEAD></HEAD><BODY><P>I guess another way to ask the question I have is.</P><P></P><P>Is there&nbsp;a way to populate an attribute table with records from an Excel Spreadsheet which doesn't have a Lat and Long&nbsp;field&nbsp;through the Field Calculator</P></BODY></HTML> Fri, 13 Jul 2018 14:20:47 GMT https://community.esri.com/t5/geodatabase-questions/joining-tables/m-p/744973#M342 SLouq 2018-07-13T14:20:47Z Re: Joining tables https://community.esri.com/t5/geodatabase-questions/joining-tables/m-p/744974#M343 <HTML><HEAD></HEAD><BODY><P>Joins work.&nbsp; The excel table doesn't need coordinates, it only needs a field which matches (name doesn't need to be the same) the file which has the geometry</P></BODY></HTML> Fri, 13 Jul 2018 16:32:20 GMT https://community.esri.com/t5/geodatabase-questions/joining-tables/m-p/744974#M343 DanPatterson_Retired 2018-07-13T16:32:20Z