topic Re: Export Survey123 data with repeated question in ArcGIS Survey123 Questions

Export Survey123 data with repeated question

Anonymous User — Tue, 26 Oct 2021 18:47:06 GMT

Hello,

I designed a pretty straight forward survey with one repeated group question. Some of the responses in the repeated question have 20+ responses. Is there a way to export the survey results with their corresponding repeated question responses?

Re: Export Survey123 data with repeated question

ZacharySutherby — Tue, 26 Oct 2021 22:24:16 GMT

Hello @Anonymous User,

Can you expand a little more in what format you would like the data exported? If you export the data in an Excel spreadsheet each related table will get it's own worksheet. Survey123 uses GlobalID to ParentGlobalID relationships to relate records from a related table to the parent table. In the exported Excel spreadsheet you will have the Global ID in the parent table as well as the ParentGlobalID in the related table which will match. If you would like to merge the tables you can use the GlobalID/ParentGlobalID columns in both tables to merge them together.

Re: Export Survey123 data with repeated question

Anonymous User — Wed, 27 Oct 2021 11:48:39 GMT

Hi Zach,

Thank you for your response! I am looking to export in an Excel spreadsheet. I had found the GlobalID/ParentGlobalID relationship but didn't think about merging the worksheets using a formula. That's exactly the answer I was hoping for. Thank you for your help!