Community
Select to view content in your preferred language

related tables in pop-ups using arcade

534
1
02-01-2021 10:21 PM
JoseBarrios1
by
Frequent Contributor
‎02-01-2021 10:21 PM

Does anyone have a  simple example for displaying related table data on a pop-up in using Arcade expression?  There is a old post here related to this topic using FeatureSets but it was not clear to me!. I have a very simple county layer with a county ID (FIPS) and a related table with the same FIPS field and other fields with species information (TAXA: bird, reptile, fish;  and STATUS: endangered, At-risk, concern , Sustainable). I want to display a summary of those related fields on the pop-up (see sample image below) . Thanks for any help on this , I am new to arcade and I'm looking forward to learn more about how to use this new tools!

Thanks!

JB

pop-up.png

0 Kudos
1 Reply
XanderBakker
by Esri Esteemed Contributor
Esri Esteemed Contributor
‎02-02-2021 05:12 AM

Hi @JoseBarrios1 ,

Paul Barker has some posts explaining how to use FeatureSets, but I think this one about using FeatureSetByRelationshipName (to get access to the related records in the table) and the GroupBy (get count per specie)  function is probably what you are looking for: 

https://www.esri.com/arcgis-blog/products/arcgis-online/mapping/whats-new-in-arcade/ 

Your options depend highly on how your data is stored. Do you have relationship classes? Do you have a 1:M relationship? etc...