topic Re: Obtain Globalid From Another Table in ArcGIS Pro Questions

Obtain Globalid From Another Table

KellyArmstrong — Wed, 09 Jun 2021 16:00:49 GMT

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?

Re: Obtain Globalid From Another Table

DanPatterson — Tue, 08 Jun 2021 22:38:11 GMT

joins?

Join Field (Data Management)—ArcGIS Pro | Documentation

Add Join (Data Management)—ArcGIS Pro | Documentation

or similar? That latter join is temporary

Re: Obtain Globalid From Another Table

KellyArmstrong — Tue, 08 Jun 2021 22:52:32 GMT

Dan,

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

Re: Obtain Globalid From Another Table

DanPatterson — Wed, 09 Jun 2021 00:25:50 GMT

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

Add Relate (Data Management)—ArcGIS Pro | Documentation

Re: Obtain Globalid From Another Table

KellyArmstrong — Wed, 09 Jun 2021 14:12:00 GMT

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...