topic Re: Calculate Field from related table in ArcGIS Pro Questions

Calculate Field from related table

janderson_ksninc — Thu, 16 Feb 2023 21:28:45 GMT

I have a table of points from field observations and a related table holding the pictures for each point. I need to rename the photos after the ID of the point. I would like to take the value from the ID field of the points and use it to replace the attachment name, then concatenate a ".jpg" and the end of the string. Is there an Arcade Expression that does this?

Re: Calculate Field from related table

RhettZufelt — Thu, 16 Feb 2023 23:28:42 GMT

Not sure of a way in Arcade, but very doable in python.

I use this on feature class with attachments enabled to update the attachment name to the id of the point (My attachments are all jpegs).

import arcpy inFeatureClass = r'Database Connections\dbname.sde\dbname.DBO.Points' # feature class with attachments pointFieldsList = ['GlobalID','ID'] # fields to load into cursor inTable = r'Database Connections\dbname.sde\dbname.DBO.Points__ATTACH' # attachment table for feature class tableFieldsList = ['REL_GLOBALID', 'DATA', 'ATT_NAME', 'ATTACHMENTID'] # field list in attachment table global_dict = {} with arcpy.da.SearchCursor(inFeatureClass, pointFieldsList) as point_cursor: # cursor to make dict of globalID's for row in point_cursor: if row[1]: row1 = row[1] # I'm using "ID" as my name field, but is else: # not always populated. if Null, substitute "NA" row1 = "NA" global_dict[row[0]] = row1 # add to dict with globallID as key, name as value with arcpy.da.UpdateCursor(inTable, tableFieldsList) as cursor: for row in cursor: if row[0] in global_dict: row[2] = global_dict[row[0]] + '.jpg' cursor.updateRow(row)

Re: Calculate Field from related table

JohannesLindner — Fri, 17 Feb 2023 07:38:47 GMT

For the Calculate Field tool with Arcade:

var related = First(FeaturesetByRelationshipName($feature, "TestPoints__ATTACHREL")) if(related == null) { return $feature.ATT_NAME } return related.OBJECTID + ".jpg"

Before:

After:

Re: Calculate Field from related table

janderson_ksninc — Fri, 17 Feb 2023 22:33:37 GMT

Thanks for responding! Would you happen to know how to do this in an Arcade Expression for an indicator in Dashboards?

Re: Calculate Field from related table

JohannesLindner — Sat, 18 Feb 2023 10:55:26 GMT

What do you want to show in the indicator?

Re: Calculate Field from related table

NourSalamJMT — Tue, 17 Sep 2024 19:03:16 GMT

@JohannesLindner very slick way of solving my problem. Thank you for sharing!

Re: Calculate Field from related table

TarkingtonGeospatial — Tue, 08 Apr 2025 21:19:46 GMT

I know I'm resurrecting an old post, but whenever I use FeatureSetByRelationshipName I get an "Invalid Relationship name" error. I know the name of the relationship is corrected and the relted worked correctly because I can see the data in the pop up.

Would you happen to have any insight on how to fix this?