topic Re: how to join two sub tables to Feature Layer in Survey 123 in ArcGIS Survey123 Questions

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

VenkatDheeravath — Mon, 26 Feb 2024 06:44:03 GMT

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

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

abureaux — Mon, 26 Feb 2024 15:53:40 GMT

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.

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

VenkatDheeravath — Tue, 27 Feb 2024 00:10:11 GMT

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

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

abureaux — Tue, 27 Feb 2024 18:29:24 GMT

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.