https://community.esri.com/t5/arcgis-online-ideas/support-in-memory-joins-to-agol/idi-p/1270475 <P>As a city I am pulling parcel data from the county in 2 databases. 1 database has the layers with location for parcels, and then we must join a table to that layer for updated information. I should be able to publish this together to AGOL from Pro.</P> Wed, 22 Mar 2023 16:26:12 GMT Laura 2023-03-22T16:26:12Z https://community.esri.com/t5/arcgis-online-ideas/support-in-memory-joins-to-agol/idi-p/1270475 <P>As a city I am pulling parcel data from the county in 2 databases. 1 database has the layers with location for parcels, and then we must join a table to that layer for updated information. I should be able to publish this together to AGOL from Pro.</P> Wed, 22 Mar 2023 16:26:12 GMT https://community.esri.com/t5/arcgis-online-ideas/support-in-memory-joins-to-agol/idi-p/1270475 Laura 2023-03-22T16:26:12Z https://community.esri.com/t5/arcgis-online-ideas/support-in-memory-joins-to-agol/idc-p/1276405#M9954 <P>You can create this in AGOL today.&nbsp;</P><OL><LI>Publish your data to AGOL as a hosted service</LI><LI>Open in web map viewer CLASSIC</LI><LI>Launch analysis and select Join</LI><LI>Set up your join and be sure to check 'Store as hosted view'</LI><LI>Save</LI></OL><P>Your join is live and updating as your data updates.</P><P>In Enterprise, you can create a View layer and publish that database view as a layer. If your data is pointing back to the source it will always be live.</P> Thu, 06 Apr 2023 22:23:44 GMT https://community.esri.com/t5/arcgis-online-ideas/support-in-memory-joins-to-agol/idc-p/1276405#M9954 NorthSouthGIS 2023-04-06T22:23:44Z