I have hosted feature service that contains the feature layer and two related tables (table 1 and table 2), all of them created through Survey123(table 1 is related to table 2 as a nested repeat). My idea is to join the feature layer with table 1 (ONE TO MANY: feature layer globalid - table 1 parentglobalid), to create Join Feature Layer, and then join Join Feature Layer, with table 2 (ONE TO MANY: table1 globalid - table2 parentglobalid), so that I can have a flat table that can be queried in Operations Dashboard. I also need to update this table dynamically as new records are being entered or existing ones are modified.
The join analysis tool allows me to create the first join as expected, but doesn't allow me to check "Create results as hosted feature layer view" for the second. I imagine because at this point and trying to create a hosted view out a a hosted view.
Any suggestions or workarounds will be highly appreciated.
Thanks.
Javier