topic Re: Related Tables in ArcGIS Online. Can I change the identifying field used to connect the related records? in ArcGIS Online Questions

Related Tables in ArcGIS Online. Can I change the identifying field used to connect the related records?

MichaelTorbett — Mon, 08 Jan 2018 20:37:29 GMT

Trying to create a feature service with related table in ArcGIS Online.

I've got some sql database data that has a lot of missing information in several records. In order to successfully create a relationship class that relates all records, I've had to create a new field that combines two existing fields in the attribute table. Now that all of my records are related correctly, I want to publish it to AGOL and use a different field to link the records for all new data going forward. Is this possible?

Thanks,

Michael

Re: Related Tables in ArcGIS Online. Can I change the identifying field used to connect the related records?

Anonymous User — Wed, 10 Jan 2018 17:25:12 GMT

Is this data hosted on AGOL? Or is it being accessed via a service into AGOL?

I know the Migrate Relationship Class—Data Management toolbox | ArcGIS Desktop is useful in the DT environment. You can always overwrite the hosted FC with the migrated relationship class

Re: Related Tables in ArcGIS Online. Can I change the identifying field used to connect the related records?

MichaelTorbett — Wed, 10 Jan 2018 18:19:02 GMT

Hey Andrew,

Thank you for the reply. The feature service is a hosted on AGOL.

I've tried using the Migrate Relationship Class Tool, but unfortunately it only seems to work if you're using the Object ID as the key. I spoke with ESRI about it this morning and so far it seems that there isn't a way to change the key fields in AGOL. I'm afraid what I may have to do is keep the current feature service as a read only archive (to maintain the current relationship) and then publish a new service for new entry's going forward that will relate by global ID.

This data is ultimately going to be collected with Collector.

Re: Related Tables in ArcGIS Online. Can I change the identifying field used to connect the related records?

Anonymous User — Wed, 10 Jan 2018 18:23:59 GMT

If the data isn't sensitive, I can take a look on my side and see if some Python can get us around this if you send it this way

Re: Related Tables in ArcGIS Online. Can I change the identifying field used to connect the related records?

MichaelTorbett — Thu, 11 Jan 2018 20:19:23 GMT

Hey Andrew, a work around in Python would be great. Unfortunately the data is sensitive. We have a contract with the feds that prohibits me from sharing the information. When I have a little time, maybe I'll create some similar dummy data and send it to you. Thank you for the offer.

Re: Related Tables in ArcGIS Online. Can I change the identifying field used to connect the related records?

Anonymous User — Fri, 12 Jan 2018 14:49:33 GMT

Classic feds and their sensitive data

I'll dedicate a few minutes to this and see what I can come up with