topic Re: Arcade Code for joining to hosted table for using it on Dashboard in ArcGIS Dashboards Questions

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

anonymous55 — Thu, 12 May 2022 17:22:25 GMT

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

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

jcarlson — Thu, 12 May 2022 17:30:07 GMT

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

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

Soobin-Choi — Fri, 27 May 2022 22:38:27 GMT

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.

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

StephenKaranja — Sat, 14 Dec 2024 19:50:33 GMT

Thanks for the info.

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