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?
joins?
Join Field (Data Management)—ArcGIS Pro | Documentation
Add Join (Data Management)—ArcGIS Pro | Documentation
or similar? That latter join is temporary
Dan,
Even if the stand-alone table / related table has multiple entries with the same objectid?
Kelly, just below the add join is "relate" (many to one)
Add Relate (Data Management)—ArcGIS Pro | Documentation
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...