how to join two sub tables to Feature Layer in Survey 123

Question

Dear Freinds,

I have used two repeat functions in Survey 123 form, so I have two sub-tables and one feature class layer. I downloaded the data, but how do I merge them into one file? I tried with global iD, but it doesn't work:(

I thought they would come into one master table like in Kobo:) But they are three separate files now:(

Actually, my structure is like the one below I need to join the data of two sub-tables to the feature layer which is downloaded from ArcGIS online/Survery123

* Geopoint* Table 1 * Table 2

Appreciate your help!!!

Best Regards

Venkat

.

abureaux · Answer

Sorry. I am still negotiating to get ArcPro for myself 😞

This can be fairly quick in Excel with something like index(match()), but I haven't had the opportunity to try in ArcPro myself yet.

I believe this person has a similar requirement/setup to you.

VenkatDheeravath · Answer

Thank you, sir. I am not using any script, but I wanted to use ArcGIS Pro. I would appreciate it if you could guide me -regards

abureaux · Answer

You need to use a combination of fields.

uniquerowid/RowID (parent) > connects to the parentrowid/ParentRowID (child). Keep going down this line for nested repeats.