Merging layers from Survey with repeats

[KeneilwePholo2]

Hi

I have created a survey on survey 123. My survey has repeats. So now when I create a webmap and dashboard, the feature layer has 2 layers named survey and property details. I would like to merge these two layers so that I can create my dashboard using one layer. The reason I am not merging the layers outside of AGOL is because the survey is updated regularly by field workers and I do not want to miss any updates on the original feature layer, is there a way for me to merge the two layers together so that I have all the details under one feature layer? This would help in my dashboard building because I need to link the property details to the date etc.

[DominicRoberge2]

Hello

could you try to create a hosted feature view in map viewer using the Analysis/Join Features? That way you should have all your data into one layer to use within Dashboard.

Hope that works for you 

[KeneilwePholo2]

Thank you
I will try this

[DougBrowning]

Any joins will be static and need to rerun.  For fully dynamic lookups checkout the FeatureSet functions in Arcade.  https://www.esri.com/arcgis-blog/products/mapping/mapping/whats-new-with-arcade-taking-a-stroll-thro...

[KeneilwePholo2]

Thank you.
I will try this.