topic Re: Is it possible to update only part of an enterprise geodatabase table? in Data Management Questions https://community.esri.com/t5/data-management-questions/is-it-possible-to-update-only-part-of-an/m-p/157828#M8839 <HTML><HEAD></HEAD><BODY><P>Do you have an identifier for those that are state units? You could query those and delete those rows then append the new rows.</P><P>Or</P><P>if you have a unique id you could join the two tables and use field calculator to move data to the existing records</P><P></P><P>You may want to set a test environment to play with these options, so you wouldn't mess with your good data</P></BODY></HTML> Tue, 26 Apr 2016 19:02:25 GMT WesMiller 2016-04-26T19:02:25Z Is it possible to update only part of an enterprise geodatabase table? https://community.esri.com/t5/data-management-questions/is-it-possible-to-update-only-part-of-an/m-p/157827#M8838 <HTML><HEAD></HEAD><BODY><P>I have a feature class on an SQL server enterprise geodatabase of Oil and Gas units. It has 75 records with fields like UnitID, name, status, type &amp; admin. 5 of those units(records) are federal and are manually updated. The rest are state units and are tracked/updated thru a different table. How do I update the attributes of the state units only with attributes from the other table without overwriting the federal unit attributes. I've tried joins, and load data but couldn't figure it out.</P></BODY></HTML> Tue, 26 Apr 2016 18:44:32 GMT https://community.esri.com/t5/data-management-questions/is-it-possible-to-update-only-part-of-an/m-p/157827#M8838 SeanConlon 2016-04-26T18:44:32Z Re: Is it possible to update only part of an enterprise geodatabase table? https://community.esri.com/t5/data-management-questions/is-it-possible-to-update-only-part-of-an/m-p/157828#M8839 <HTML><HEAD></HEAD><BODY><P>Do you have an identifier for those that are state units? You could query those and delete those rows then append the new rows.</P><P>Or</P><P>if you have a unique id you could join the two tables and use field calculator to move data to the existing records</P><P></P><P>You may want to set a test environment to play with these options, so you wouldn't mess with your good data</P></BODY></HTML> Tue, 26 Apr 2016 19:02:25 GMT https://community.esri.com/t5/data-management-questions/is-it-possible-to-update-only-part-of-an/m-p/157828#M8839 WesMiller 2016-04-26T19:02:25Z