topic calculate field in ArcGIS Pro Questions

calculate field

MohammedElsayed — Wed, 05 May 2021 09:32:29 GMT

is there a way to calculate a field in a table from data in another table in SQL database?

the case is I have two tables in a database both have the same IDs, so I want to fill a column in one table from the a column in the other table.

i tried to write a code but it did not work as I'm still a beginner in coding.

if Charts_Limits['SURVEY_ID_REF'] == Survey_Limit_Polygon['SURVEY_ID_REF']:

Charts_Limits['Survey_Type_Updated'].append(Survey_Limit_Polygon['Survey_Type_Updated'])

Re: calculate field

DanPatterson — Wed, 05 May 2021 11:05:29 GMT

Temporarily join the tables and calculate your field in the target table using the field in the join table. When done, remove the join.

As a note, if you are trying to update values in the target table, you can always make a query/selection prior to doing the calculation. Field calculations are only done on selected records

Re: calculate field

RobertBorchert — Thu, 06 May 2021 18:06:05 GMT

Can you put the two features into a relationship?

This SQL code works in a definition query for features in a relationship.

Table1 Table2 Table2 Table2

ORIGINFIELD IN (SELECT DESTINATIONFIELD FROM <RELATED NAME> where <FIELDNAME> <QUERY>)

I use it to show only points in a Dashboard that have an attachment associated with it. It may work with a SQL query for Labels.