How should I merge the data from a repeat group to the main data?

[Kal_Lam]

Welcome to the community, @petranilla! Maybe these post discussed previously should help you solve your issue:

Household roster information missing in xls data-set downloaded from KoBoToolbox

Hi @Hans, Please be informed that KoBoToolbox does not offer you the feature of merging household roster data-set with the main data-set that you have collected. The information provided below is just an idea of what you should look over to so that you could use some third party software to merge your data-set. You generally see 2 or maybe more sheets in your downloaded xls dataset when you have repeat group questions within your survey questionnaire. Please note that the first sheet that i…

And this post too …

Using SPSS to Merge Data from the Different Sheets in XLS from a Form that had Repeating Groups using SPSS

Hi @fieldwork19 To fully do what you are looking for i is important to note the following behaviors around KoBoToolBox & integrating IBM (SPSS) 1… If you have repeating groups KoBoToolBox stores each group within its own sheet in the excel. The repeats from one questionnaire administration (instance) will be linked to the main part (non repeating) questionnaire with the index (I believe you already knew this.) When working with SPSS or event STATA there are two data formats, long format a…