Combining all data for survey point from multiple CSV files that were exported from Survey123 data.

510
1
10-03-2019 12:39 PM
MichaelMerriman
New Contributor

Because my survey had repeats, each repeat group was exported from Survey123 as a separate excel spreadsheet. I am looking for a way to have all the info from one point in one row. Is there a way to do this? I am having trouble figuring out if there is a unique ID for each spreadsheet that links the data to the point. The only shared column headings I am seeing are ObjectID and GlobalID, which aren't seeming to match up when I look at an individual completed survey form and two rows with the same values in those columns.

0 Kudos
1 Reply
DougBrowning
MVP Esteemed Contributor

The repeat should have a parentGlobalID field.  That joins to the GlobalId of the parent.

You can also just export to GDB and this relationship will come built in.