Arcade Code for joining to hosted table for using it on Dashboard

[anonymous55]

Hello All,

I am looking for a arcade code which I can bring one or two fields from another table and join it with another hosted table then use it on dashboard as Table or list. 
I don't know if this is possible using Arcade? I can use join function in arcgis online but how can I keep that up to date 

[jcarlson · Accepted solution]

It sounds like you could use a Data Expression! There is an example expression for just such a scenario right here: https://github.com/Esri/arcade-expressions/blob/master/dashboard_data/JoinLayerFieldsToTable.md 

[StephenKaranja]

Thanks for the info.

The link seems to have changed. It is now: https://github.com/Esri/arcade-expressions/blob/master/dashboard/dashboard_data/JoinLayerFieldsToTab...

[Soobin-Choi · Accepted solution]

Hi there,

Another method would be to use a field join to join the tables/layers from Map Viewer, then publishing the joined result as a feature layer view. 

 

Credit is not required and the data will stay up to date. Depending on the size of your dataset, using data expressions to "join" tables may cause a performance lag when loading dashboard elements. This view option might be a more scalable alternative.