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

Question

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

Anonymous User · Answer

Classic feds and their sensitive data

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

MichaelTorbett · Answer

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.

Anonymous User · Answer

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