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

Question

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 Answer

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

Soobin-Choi · Accepted Answer

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.