Display Related Data Table Values in WebMap Popup

[BrianMoore2]

Hi,

I’m trying to display values from both a Feature Layer and related Date Table in WebMap popup in ArcGIS Online.

This is simple enough for the Feature Layer as all the fields are available by default but I’m unclear how to display the last vale for a field from the related Data Table.

I have been able to display a count of the total recorded values for a field from the related Data Table but not the last value.

Please can anybody point me in the right direction? Thanks.

ArcGISOnline‌ AGISOL RelatedDataTable‌ Popup

[BrianMoore2 · Accepted solution]

Here is how its done for anybody else with the same query.

1. Adding the required Feature Layer and Related Data Table to a WebMap
2. Clicking the Analysis tab, select Join Features
3. Add the Feature Layer as the target layer
4. Add the Related Data Table as the join
5. Choose fields to match (in most cases this will be the 'Global ID' and the 'Asset GUID' fields)
6. Join One to One
7. Define which record is kept, order by EditDate, Newest
8. Select 'Create results as Feature Layer hosted'

#FeatureLayerView #JoinFeatures