Show all related or joined attributes in a popup

AlexMetzler

My end goal is to view all related attributes in a popup in ArcGIS Online. I have a polygon feature class of buildings and a table of offices. Many offices can belong to one building. For example...

Building_ID	Name
001	Building1
002	Building2
003	Building3

Building_ID	OfficeName
001	OfficeA
001	OfficeB
002	OfficeC
002	OfficeD

The popup would look like this...

Building1 OfficeA OfficeB

I am using ArcMap 10.7, SQL Server EGDB, standalone ArcGIS Server, and ArcGIS Online.

• It seems doing a Join, I can do a one-to-many that produces duplicate features/records for each Office.
• Publishing a relationship class provides a link to show related records but cannot be used to list attributes in the popup.
• I've used Arcade before to reference other AGOL layers for popup content but am not sure the best setup to publishing the feature class and table (feature v. map service) for this to be as smooth as possible.
• Also, thinking ahead to creating a View in the enterprise geodatabase, seems it would create multiple features like a join.

Any ideas how I can get the desired result of showing the related/joined attributes in a popup?

XanderBakker

Hi Alex Metzler ,

I would probably just use a feature service. Publish the building featureclass and the table and create a web map with both the hosted feature layer and the table in it and then create a simple Arcade expression on the hosted feature layer pop-up:

<SPAN class="keyword token">var</SPAN> building_id <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Building_ID"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> office_tbl <SPAN class="operator token">=</SPAN> <SPAN class="token function">FeatureSetByName</SPAN><SPAN class="punctuation token">(</SPAN>$map<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Offices"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> sql <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Building_ID = '"</SPAN> <SPAN class="operator token">+</SPAN> building_id <SPAN class="operator token">+</SPAN> <SPAN class="string token">"'"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> offices <SPAN class="operator token">=</SPAN> <SPAN class="token function">Filter</SPAN><SPAN class="punctuation token">(</SPAN>office_tbl<SPAN class="punctuation token">,</SPAN> sql<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> cnt <SPAN class="operator token">=</SPAN> <SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN>offices<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">var</SPAN> result <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Building: "</SPAN> <SPAN class="operator token">+</SPAN> building_id<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>cnt <SPAN class="operator token">></SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">for</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> office <SPAN class="keyword token">in</SPAN> offices<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
        result <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> TextFormatting<SPAN class="punctuation token">.</SPAN>NewLine <SPAN class="operator token">+</SPAN> <SPAN class="string token">" - "</SPAN> <SPAN class="operator token">+</SPAN> office<SPAN class="punctuation token">.</SPAN>OfficeName<SPAN class="punctuation token">;</SPAN>
    <SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
    result <SPAN class="operator token">+</SPAN><SPAN class="operator token">=</SPAN> TextFormatting<SPAN class="punctuation token">.</SPAN>NewLine <SPAN class="operator token">+</SPAN> <SPAN class="string token">" - No offices in this building"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN>

<SPAN class="keyword token">return</SPAN> result<SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>