topic Arcade Expression: Combine Multiple Layers in ArcGIS Dashboards Questions

Arcade Expression: Combine Multiple Layers

dwold — Fri, 14 Jul 2023 15:36:31 GMT

I found this but I am not a developer and cannot really interpret and make it work for the data I want to use. I would like to combine two tables/attribute fields together.

Layer/Table names are Assessment and IndicatorAssessment.

I'd like to combine all fields but specifically, I need the Name field from Assessment and Lifeline, Component, Indicator, and Trend fields from IndicatorAssessment in one new layer

I want to use that new data expression for an element in my dashboard

Re: Arcade Expression: Combine Multiple Layers

JohannesLindner — Fri, 14 Jul 2023 23:29:54 GMT

The expression you found executes a Merge: Take two (or more) datasets with the same fields and copy all rows of those datasets into a new dataset.

What you describe sounds like a Join: Assign the rows of one dataset to the rows of another dataset (different fields) based on the values of a common field.

Can you please confirm which of these you want? Also, if you want a join, what is the common field?

Re: Arcade Expression: Combine Multiple Layers

dwold — Mon, 17 Jul 2023 19:26:33 GMT

@JohannesLindner I eventually got it to work. Thank you for your suggestions!