Kal_Lam
December 3, 2020, 11:14am
2
Maybe these post discussed previously should help you merge your dataset from a roster to the main sheet:
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,…
This too …
Hi @mmarwa ,
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 is generally seen when opening your xls dataset is the main dataset. This dataset contains a variable named _index. If you go to the next sheet (which should be your first repeat group sheet) you should see a variable named _parent_index.
Theoretically, the number of cases in your first sheet (default s…
This too …
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…
Note: The feature of merging roster data to the main dataset is currently not available with KoBoToolbox and you will have to merge them manually using some third party software.
1 Like
