My results appear in a different sheet. Why?

User Support Data Management
, ,
1

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

3

image
image2016×1512 1.06 MB

those are different four sheet appear after data being downloded

1 Like
4

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
7

Thanks Kal_Lam. It worked for me.