I need to auto populate field data in one table using the reference of other table. I tried this using some sql scripting in arcpy. using the script I was able to pull the data from table but not modifying of the data.
<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="comment token"># Use a connection file to create the connection</SPAN>
egdb <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\Users\mlgsadmin\AppData\Roaming\ESRI\Desktop10.6\ArcCatalog\Connection to 10.72.15.186.sde'</SPAN>
egdb_conn <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ArcSDESQLExecute<SPAN class="punctuation token">(</SPAN>egdb<SPAN class="punctuation token">)</SPAN>
table_name <SPAN class="operator token">=</SPAN> <SPAN class="string token">'SDE.BPPL_Overall_Status'</SPAN>
field_name <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Status'</SPAN>
sql <SPAN class="operator token">=</SPAN> <SPAN class="string token">'''
UPDATE SDE.BPPL_Overall_Status
SET BPPL_Overall_Status.Clearing = Cleraing_ROW_0_175_Km.STATUS
from BPPL_Overall_Status
Inner Join Cleraing_ROW_0_175_Km
ON BPPL_Overall_Status.Start_mts=Cleraing_ROW_0_175_Km.Start_mts
'''</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>field_name<SPAN class="punctuation token">,</SPAN> table_name<SPAN class="punctuation token">)</SPAN>
egdb_return <SPAN class="operator token">=</SPAN> egdb_conn<SPAN class="punctuation token">.</SPAN>execute<SPAN class="punctuation token">(</SPAN>sql<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN></SPAN>
This was the script used.
