Using Pull Data to Pull Data from Repeat Groups Workaround

[Kal_Lam]

Maybe this post discussed previously should help you understand on merging a repeat group dataset to the main sheet:

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…