AnsweredAssumed Answered

Join table Survey123 non-spatial table with AGOL hosted feature layer

Question asked by leonilindro on Jul 10, 2019
Latest reply on Apr 1, 2020 by cinthia_eichhorn@fws.gov_fws

Hi friends,


I have developed a survey in Survey123 ( which doesn't collect location data. It generates a Feature Layer (hosted) in my AGOL Content and has an associated table with it. I think all the records in the Survey123 table gets a coordinate Lat:0/ Long:0, as they are plotted near Africa in the ocean. One of the fields in the table has names of States in India, which comes from one of the questions that each survey participant has to answer. At the same time, I have uploaded a shapefile as a Feature Layer (hosted) in my AGOL Content having a field with State names.


I want to join these two tables, using the State Name field in both the tables, and generate a choropleth map to display the number of responses from each state. Also to summarize other data on the map state-wise. I has hoping that as the tally of respondents change across each state over time, it will result in a dynamic choropleth map. Unfortunately, the join operation fails. I don't know why. Can anyone help me with this?