My results appear in a different sheet. Why?

I managed to construct form with matrix questions and household rooster question and collect data using enketo but after downloaded the form in xls, result appear in different sheets according to matrix question I set first instead of all answer to appear in one sheet , your assistance on this

those are different four sheet appear after data being downloded

1 Like

Hi @exaud1993,

Welcome to the community! Kindly please be informed that if you are designing a matrix question you should generally see the results of the same in the main dataset. However if you have a repeat group question type (i.e. a roster question) the same stays in the next sheet (i.e. not in the main sheet).

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.

Have a great day!

1 Like

Thanks Kal_Lam. It worked for me.