Obtain Globalid From Another Table

173
4
2 weeks ago
KellyArmstrong
Occasional Contributor II

I have a standalone table that has an id field named "media_table_id".  I also have a feature class that has an id field with those same values and it has a globalid field.  I would like to be able to populate my standalone table with the globalid's from the feature class, where the id's match and contains 'tbl_flare_ends" from the layername field in the standalone table. 

Would I need to write an sql to do this?  Something like:  standalone.media_table_id = feature_class.id_field WHERE standalone.layername = 'tbl_flare_ends' ?  Or would I have to do some type of join to populate globalid values that match the criteria?

0 Kudos
4 Replies
DanPatterson
MVP Honored Contributor

joins?

Join Field (Data Management)—ArcGIS Pro | Documentation

Add Join (Data Management)—ArcGIS Pro | Documentation

or similar?  That latter join is temporary 


... sort of retired...
0 Kudos
KellyArmstrong
Occasional Contributor II

Dan,

Even if the stand-alone table / related table has multiple entries with the same objectid?

0 Kudos
DanPatterson
MVP Honored Contributor

Kelly, just below the add join is "relate"  (many to one)

Add Relate (Data Management)—ArcGIS Pro | Documentation


... sort of retired...
0 Kudos
KellyArmstrong
Occasional Contributor II

Thanks Dan.

When joining, it does not bring the globalid field with, so I am not able to calculate a new field with those values...

0 Kudos