Hi @Olimpia ,
Please find attached (ODK_example_2_alt_AM.xlsx (12.3 KB) ) a possible "streamlined" version of the questionnaire.
Main suggested modifications include:
- The first person of the roster must be the HH head. It should be fairly easy to identify and it does not require other information to be answered (see also Repeat a question only if specific question is selected for the person on the first position - #6 by Andrea_Martin)
- Allow the user to register as many hh members as needed (while if you force the respondent to tell you in advance the number they might forget someone and later it might be more complicated to add)
- Use answers in the roster to calculate the information you need (e.g. hh size is a count of the repeat loops)
- Key 'yes' and 'no' as 1 and 0, this way (when needed) you can easily count how many hh member meet a certain criteria in a loop by simply summing that field
- the roster usually comes first in the questionnaire and details about the house in general (e.g. WASH) are asked later, once the numerator has already familiarized with the respondents
For the export part, are using ODK Aggregate export feature?
I would suggest you try using ODK briefcase instead. Once you export the submissions, you will have separate csv files for each repeat group, which you can merge using the parent_key field.
I hope this helps!
Ciao,
Andrea