Relational join without creating a new hosted feature layer?

Question

Hi

I have a hosted feature layer in my ArcGIS Online content that contains district boundaries in my authority and includes a boundary code ID field.

Each week statistics are generated for each district as a CSV file and I wish to be able to upload and replace this CSV to ArcGIS Online and to add a relational join to my hosted feature layer - I don't want to have to generate  a new hosted feature layer each week as that seems to just add additional work to the workflow.

Are there options to add relational joins between hosted layers and CSV files so I can just update the separate CSV without having to manipulate the hosted feature layer?

Thanks

ChrisBuckmaster2 · Answer

Thanks Scott Moore (Olympia)‌ that seemed to work I think!

What I would say is that it probably isn't the most logical way of being able to update the data, as I didn't seem to be able to do it through the item's main page.

Hopefully the analytics team can review and improve the experience as it must be a fairly common use case.

ScottMoore__Olympia_ · Answer

Ok, I wonder if it would work for you to go into the services directory for the hosted table and delete all of the records and then use the append through the item details page.

Maybe try this and see if it works for you.  The analytics team is looking at this so they may use this use case to improve the experience.

ChrisBuckmaster2 · Answer

Following on from this, I deleted the hosted feature layer view from the join and the option to now overwrite my CSV layer exists, but I don't want to delete the joined feature layer view, simply just update the CSV file without having to do that workflow again.

Scott Moore (Olympia)‌ can you confirm that I should indeed be able to overwrite my hosted CSV table after it has been used in a hosted feature layer view join?