Merging roster data

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.

2 Likes

Apart from @osmanburcu mentioned,

There is also _submission__id in the subsheets match with _id in main sheet :+1:

1 Like

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.

2 Likes

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: