Export Survey123 data with repeated question

669
2
10-26-2021 11:47 AM
by Anonymous User
Not applicable

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?

0 Kudos
2 Replies
ZacharySutherby
Esri Regular Contributor

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

Thank you,
Zach
by Anonymous User
Not applicable

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!

0 Kudos