I created a repeat group that shows only when a specific response is given in a field before. Either with Enketo or on the Android app, the repeat group works well. On the device I can also see the data entered in the repeat group after the form got sent. But the data from the repeat group is not loading in Power Query, I don’t get a second table to load. I checked with downloading the XLS sheet from Kobo, but it doesn’t include a seperate sheeet.
This is the programming I used in my XLS form under the Relevant column when the repeat group should show.
My issue is not so much on how to set it up in Power Query, but more so that it does not give me the option to transform a second table with repeat group data. Here is a screenshot from Power Query, in the “Navigator” window it only shows me the main table to load but not another one where my repeat group data should be included
As mentioned above, when downloading the Excel file directly from Kobo (see first screenshot), the file also does not include a second sheet. However, I can see on my tablet that data has been entered into the repeat group and it is listed under forms that were sent.
Hi there, to conlcude this and in case someone else has a similar issue. In the end I made it work with moving the command in the relevant column from the begin_repear row into the row of each field of the repeat group (like I had tested it above).
It loaded all data after the updated form got published, even data that was collected with the earlier/faulty form!
