Household roster information missing in xls data-set downloaded from KoBoToolbox

[Kal_Lam]

Hi @Hans,

You could merge the roster data with the main data-set as outlined in the discussion that has happened earlier:

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…

Have a great day!