Select to view content in your preferred language

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

481
3
02-25-2024 10:34 PM
VenkatDheeravath
Emerging Contributor

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

.

0 Kudos
3 Replies
abureaux
MVP Frequent Contributor

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.

abureaux_0-1708962749907.png

 

0 Kudos
VenkatDheeravath
Emerging Contributor

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 

0 Kudos
abureaux
MVP Frequent Contributor

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.

0 Kudos