Download databases

[DenissouJoel]

Download data from a group form: What to do when data related to bundled questions are not found after teloading?

[stephanealoo]

HI
Normally when you have data from a repeat group, the data will be stored in their own sheet. You should see them when you download the XLS version of the data. You can link the data using the parent key on the main sheet.

Stephane

[DenissouJoel]

Bien reçu.
Merci beaucoup.

[DenissouJoel]

Salut à tous,
Salut Stephane.
J’ai réussi à télécharger mes données avec les groupes qui sont dans leurs feuilles respectives.
Maintenant, je veux lier les données des groupes au fichier principal en utilisant les les index_parent. Y a t-il une manière automatique de le faire de sorte qu’après la liaison avec un index_parent je puisse incrémenter pour les autres ? (J’ai jusqu’à 158 individus donc 158 index_parents. Ce serait rébarbatif si je dois aller index par index). Avez-vous une solution à me proposer ?
Merci d’avance.

[Kal_Lam]

Hi @DenissouJoel,

KoBoToolbox at the moment does not offer you the feature of merging data-set like the one you have requested for. However, you could merge the same using some third party software viz. SPSS, STATA etc.

For reference, you could also have a look at a workaround on merging data-set using SPSS that has been discussed earlier:

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!

[DenissouJoel]

@Kal_Lam

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…

Hi @Kal_Lam,
Thank you for your response.
I will try…

[DenissouJoel]

Merci.

Je n’ai pas pu lire tout le message avec @fieldwork19 .

Je veux utiliser Stata. De façon pratique, comment ça se passe? Quelles syntaxes dois-je utiliser ?

[Kal_Lam]

Hi @DenissouJoel,

The main principle on merging the data-set is the same whether you use SPSS, STATA or any other software. Please follow the principle outlined in the discussion that has been explained previously:

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…

Have a great day!