Merging repeat data

Dear ODK central teams,

I have one questions which is labelling and merging repeated data. On odkmeta it is easy to merge the repeated data but on ODK central, I couldn't merge the data. It request SET-OF variables which generated automatically on odkmeta but on ODK central it doesn't appear. So, can you help me please.

Hi and welcome, @talilebedasa1 . Can you please tell us a little bit more about what you're trying to do and where you're getting stuck?

ODK Central gives you two main ways of accessing data: downloading CSVs or connecting to the OData feed with Excel, PowerBI, etc. If you have repeats, the data from the form top-level will be in one "table" and the repeats will be separate "tables". Each repeat table has a PARENT_KEY that can be used to link up to its parent.

It sounds like you would like a representation where each row from a repeat also includes the data from the top-level, is that right? If you confirm this and tell us what analysis software you're using, we should be able to offer you some guidance.

We always appreciate hearing about community members' projects. When you have a moment, please introduce yourself!