@vikassamvad2020 , please be informed that you generally get the data in different sheet when you use the repeat group question within your survey project. For better understanding please feel free to have a look at the post discussed previously:
Hi @fieldwork19 ,
Please have a look at the image attached below. It’s a sample of the xls dataset downloaded from the KoBoToolbox server.
[Image%201111]
1 viz. Survey is the sheet containing the main dataset. 2 viz. D_O_O is the sheet containing the repeat group responses. Similarly, 3 viz. DO_O is the sheet containing the repeat group responses.
So, generally in a dataset you will have only one 1 sheet while you may have many sheets like 2 or 3 (depending upon your questionnaire).
Besides,…
So as a workaround you will need to merge them to a separate sheet as discussed in this post:
Hi team,
I have an issue with my data. My questionnaire is grouped into subsets. when i download it comes in different sheets this is not easy for analysing, how do i make themappear in one ? please help me out… Regards
or
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…
1 Like
