Hello! I am pretty new to ArcGIS and Survey123 and I have recently created a Survey123 form for some of our field work. The form has questions which only appear once as well as some repeating questions that will have multiple responses per submission. I have uploaded this data into ArcGIS and noticed that the data from the survey got divided into several tables (Figure 1).
Figure 1. Survey is the main table. Each table below was created from a repeating question in the survey.
In the survey table, there is the SiteID, which is something I'd like to have appear in every table. It's connected to the GlobalID.
In one of the subsequent tables, the ParentGlobalID appears which is the same as the global ID in the survey table. I'm trying to have the SiteID column appear in all the tables that don't currently it and thought there would be a way to connect them through the GlobalID. However, in the other tables, all of the Global IDs are different.
I am trying to have the SiteID appear in each table through the connection between the GlobalID in the survey table and the ParentGlobalID that appears in each subsequent table. I'm having a lot of trouble doing this though. I've tried using the Join feature but haven't had much success. I'd like to copy the SiteID in the survey table and place it in every other table based on the ParentGlobalID but I'm not sure if that's possible or if there's workaround I could do to make that happen. Any thoughts about how I could do this?
