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
Appreciate your help!!!
Best Regards
Venkat
.
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.
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
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.