Group questions Data

[Kal_Lam]

Hi @fieldwork19,

You will need to merge the datasets (in either SPSS, stata or similar third party software) and then analyze as per your need.

A discussion has happened in the past in the community forum, which outlines on merging the dataset (roster dataset and main dataset):

When i download my data it comes in different sheets, how do i make them appear in one?

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…

GOOD DAY!