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 and wide format. You can never merge the two formats directly without converting them.
-
Back to KoBoToolBox, the non-repeating part of the questionnaire stores the data in the long format, while the repeating groups part of the questionnaire is stored in wide format.
Given the above 3 principles, you can then map out your workflow for converting the data to SPSS. For this purpose, I will assume that you have only two repeating groups. That means your XLS form will have three sheets: the first one which contains all responses from the non-repeating group questions, sheet 2 with the first repeating group, sheet 3 with the second repeating group questions. You can the follow the steps below:
-
Step 1: Create an SPSS file for each of the sheets i.e. sheet 1, sheet 2, sheet 3. You can convert your data using import CSV function if you have created the three CSV’s from your XLS.
-
Step 2: Independently Convert Sheet 2 and Sheet three data into long format using the instructions which can be found here
-
Step 3: Using the index variable i.e. question, (you need to name them similarly in the three spss files you have in Step 1.
You should use a merge files by adding variables command
This should sort out the issue you had indicated before
Stephane
