Can Arcade create labels using data from related tables?

[JeffDavis7]

Hello,

Randy Burton was kind enough to assist me by providing some wonderful Python code for creating labels using data from related tables specific for use in ArcGIS Desktop.

I am hoping to take this a step further and provide my AGO users with same great labeling.  Randy suggested I post this question within the confines of AGO with the hope of obtaining some wise advice and direction.

Can someone please assist me in this venture?

Thank you.

Jeff

[XanderBakker · Accepted solution]

Hi Jeff Davis ,

For completeness I will add the answer also in this thread; It is not possible yo have access with Arcade in the label profile to related tables. You will need to add a field in the main featureset and fill it with the information of the related table(s) in order to show it as a label. The reason behind this is that wherever an Arcade expression needs to be executed for multiple features the functionality is limited (with the exceptions of the profiles field calculations and attribute rules) due to performance. 

Hopefully the Python code provided by Randy does not have a large impact on performance when moving around the map since it will need to executed for each label that will be shown in the map each time the map extent is changed. 

[JeffDavis7]

Thank you, Xander.

Jeff

[WD1964]

Hi Xander,

How do I go about displaying data from a related table as a label in Map Viewer (so not in ArcGIS Pro, nor in Map Viewer Classic)?

The idea is to show the names of all the occupants of various rooms as a label, so not as a pop-up. There is a one to many related table between a polygon feature representing the room and a table with names assigned to those different rooms). The purpose is to have a layout of a building that can be printed which contains all the people assigned to a room which can't be done when using pop-ups.

I realize there may be a performance issue but even if it takes a couple of minutes (or longer), it doesn't matter as in the end the information is displayed on the map and only serves to make a print.

[GrantHoward1]

Hi Xander,

you said this: "You will need to add a field in the main featureset and fill it with the information of the related table(s) in order to show it as a label."

How is that done?

Thanks,
Grant

[sofoo]

Found this "How To: Label a feature with multiple records in a joined or related table in ArcGIS Pro": 

https://support.esri.com/en/technical-article/000021133

Though this is Python and I don't understand how this logic would work.  First off how do you add a field to a query table...