AnsweredAssumed Answered

Survey Output Table

Question asked by alan.coats on Jun 13, 2018
Latest reply on Jul 19, 2018 by Philip.Wilson-esristaff

I have a long survey with 20+ distinct "repeat" sections. So far, I'm really pleased with the ability to collect polygons in Collector, pass on parameters to a Survey123 form, and continue to collect data in Survey123. I'm currently running test surveys to better understand what the output data from Survey123 looks like. After I collect the data, I plan to use the output table as a CSV for analysis. 


The best way to view my data seems to be the hosted feature layer from my survey (is this correct?). However, each individual "repeat" appears as a separate table associated with the layer, rather than having all of them in one consolidated table. Also, each of the tables is output in a "wide" format. In other words, there is only one row for each survey, and the answers to questions appear as columns. However, when it comes time to analyze the data, it will be easier to have the data in a "long" format, or one in which every survey question has an individual row, with columns in each row that identify the survey.


Of course, I can merge the tables and perform a "reshape" in R to convert the table to long-format. If that would be the best solution, that's not a big problem. However, I'm still learning Survey123, and I mostly want to make sure I'm not doing something wrong. 


Summary: Is there a way to output Survey123 results as a long-format table that includes answers from all repeat sections?


Thanks very much for your help.