topic Re: Joining Two Tables with One Feature Into One Hosted Feature Layer View in ArcGIS Online Questions

Joining Two Tables with One Feature Into One Hosted Feature Layer View

GarrettRSmith — Thu, 13 Jul 2023 21:59:06 GMT

Hello

I have a feature layer (point) and two related forms (tables) that were created via Survey123.

I am using Map Viewer Classic and the Join Features analysis tool to try and join the two tables with the feature layer. I would like to keep the join dynamic because the surveys are currently in operation and therefore want to create a hosted feature layer view. This hosted feature layer view will be used in FieldMaps and will be updated within FieldMaps every week.

I can easily create a hosted feature layer view by joining the feature layer with one of the tables, but I cannot use this new hosted feature layer view to join the additional table to. I have tried to first join both of the forms and then join this with the feature layer, but again if the combined table is a hosted feature layer view, I cannot create a hosted feature layer view from this join. Is there a way, within ArcGIS Online, to join two forms to one feature layer with the result being a hosted feature layer view? Or, is there method that I should be looking into.

Thanks for any and all help.

Re: Joining Two Tables with One Feature Into One Hosted Feature Layer View

LakeCountyCOGIS — Thu, 13 Jul 2023 22:13:23 GMT

Currently trying to figure something like this out. This link may help, I still haven't found a solution for my issue yet. Bring your data closer together: Save analysis results from Join Features as Hosted Feature Layer Views (esri.com)

Re: Joining Two Tables with One Feature Into One Hosted Feature Layer View

GarrettRSmith — Thu, 13 Jul 2023 23:01:53 GMT

Hello @LakeCountyCOGIS

I am able to create hosted feature layer view with one of the tables, I am trying to find a solution that will allow me to create a hosted feature layer view with two tables and one feature layer.

Thanks for the link though and let me know if you find a solution, if you are facing the same issue that I am.

Re: Joining Two Tables with One Feature Into One Hosted Feature Layer View

gargarcia — Fri, 14 Jul 2023 12:51:12 GMT

I'm not positive, but I don't think it is possible to make a new join view from an already existing join views.

You could have two separate join views for each table then add them both to the map with a symbology that only shows up under certain conditions. Like if table 1 status is yes it shows up and table 2 symbology is invisible, then swap if table 2 status is yes.

Or if you are not trying to symbolize off of one of the tables you can use an arcade expression to pull attributes from an intersecting feature into the popup of another.

Re: Joining Two Tables with One Feature Into One Hosted Feature Layer View

DEI — Wed, 01 Nov 2023 20:44:12 GMT

Any luck with this? I have a similar issue where I have 1 inspection point with 2 independent and dynamic tables. No problem going from point to 1 table but when I try to join the second table to that, the option to 'Create results as hosted feature layer view' is greyed out.

Re: Joining Two Tables with One Feature Into One Hosted Feature Layer View

GarrettRSmith — Thu, 21 Dec 2023 17:39:56 GMT

Hi.

I have not figured out how to do this.

Re: Joining Two Tables with One Feature Into One Hosted Feature Layer View

ChrisSchrader — Wed, 15 May 2024 19:27:03 GMT

I, too, would like to be able to join more than 2 tables in a hosted feature layer view.

Re: Joining Two Tables with One Feature Into One Hosted Feature Layer View

JoshB123 — Wed, 10 Jul 2024 15:28:51 GMT

I also really need this functionality as I have multiple tables related that I can't analyse without joining them.

I wonder if ESRI ever foreseen or considered this?

Re: Joining Two Tables with One Feature Into One Hosted Feature Layer View

EricaNova — Mon, 09 Jun 2025 17:32:27 GMT

I want to chime in as well. I have a hosted feature layer (point) with a related table that has two child tables. I want to be able to join the main point layer to two of the tables. If I had known I couldn't join them like this I might have made them in a different manner!

Re: Joining Two Tables with One Feature Into One Hosted Feature Layer View

JoshB123 — Wed, 11 Jun 2025 08:56:38 GMT

At the moment the best work-arounds are exporting your data into an SQL database, or alternatively using ArcServer to host the data natively in an SQL database and publish to AGOL as a service.

You can join all layers in AGOL using Arcade and I have managed to get this working, however it is painfully slow, because it isn't a database engine, the arcade has to iterate through rows individually