Analysis of groups in Kobo Online and Excel analyser

[mattisasav]

Hello,
I have a problem with my database. I’ve done a survey with one group to be repeated. It works fine no problem. But when I extract the data I can’t work it out on the Excel Analyser and on the Online Kobo it doesn’t appear at all. Do you have any solution to better analyse this data ?

Thank you

[Kal_Lam]

Hi @mattisasav,

Welcome to the community! Kindly please be informed that data from repeat group should be treated differently. The structure of the data that you get from the repeat group is a bit different from the one that you should get normally.

Feel free to have a look at the post discussed here to understand more on roster data:

Missing of repeated group answer

Hi @salotembe, Kindly please be informed that your data is not missing/lost. I could see the same in while downloading it at my end: FYR: [image] Kindly please note that VERIFICACAO E ANALISE DAS NE... tab in your xls dataset is the main dataset while group_mk2ls50 is the repeated group dataset. Please be informed that you will need to merge the dataset through a third party software such as SPSS, STATA etc. You could also follow the instructions outlined (to merge the dataset) that has be…

Also feel free to have a look here to learn more on how to merge the household roster with the main dataset:

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…

Have a great day!

[mattisasav]

Thank you for thoses clear answers !
Is there any free software that could do the work for this ?

[Kal_Lam]

Hi @mattisasav,

Try looking the VLOOKUP and HLOOKUP for Excel. It should also help solve you your issue.

Have a great day!