Arcade Expression: Combine Multiple Layers

Question

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

dwold · Answer

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

JohannesLindner · Answer

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?