Hi, i have a household survey that was used in the field for data collection. when i download the data, i am having three sub sheets as roster data. which variables should i use to properly merge the three sheets together? can anyone please help with that?
Hi @gannahassan,
You can use the “_index” and “_parent_index” variables to merge the sheets together. The main sheet will include only “_index” column and sub sheets will have “_index” and “_parent_index” columns. You need to get “_index” from the main sheet and “_parent_index” from the sub sheets.
Apart from @osmanburcu mentioned,
There is also _submission__id
in the subsheets match with _id
in main sheet
Hi Osman, so the _index is only in the first sheet (which is at the household level). if i only want the other sub sheets, would using _parent_index with submission__uuid work ?
No there is _index in each sheet but “_parent_index” is only appears in the sub sheets. as @hakan_cetinkaya mentioned you also can use the “_id” with same logic.
Thank you so much @osmanburcu @hakan_cetinkaya ! i think merging using _parent_indext _submission__uuid and another variable that is also across the three sheets called (work_member_name) is working. only few observations that are not matched i think maybe some inconsistencies in the data.
@gannahassan, you should be able to merge the same by following this support article shared previously in the community: