How do i merge a dataset that i get from the repeat group?

[exaud1993]

@Kal_Lam [quote=“Kal_Lam, post:4, topic:9366”]
You will need to merge the 2 dataset manually basing the _index from the main dataset with the _parent_index from the repeat group dataset.
[/quote]

I am still get confusion on how to merge data by using _index and _parent_index, your assistance on this please how can I merge the data which appear in more than one sheet due of having more than one repeat group

[Kal_Lam]

Hi @exaud1993,

Currently KoBoToolbox does not support merging dataset. For this, you will need some party software (such as SPSS, stata etc.).

You could follow the steps as outlined in a previous post to merge your dataset using SPSS:

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!

[exaud1993]

Thank you @Kal_Lam

[Kal_Lam]

@exaud1993, you should be able to merge repeat group data with the main data with Excel as outlined in the support article:

New Support Article: Merging Individual Data with Roster Data through Power Query in Excel

Dear All, Would like to inform you that we have recently added a new support article Merging Individual Data with Roster Data through Power Query in Excel to our support site. [image] Please visit our Help Center Page to learn more about other support articles. [image]