How to optimize export settings

Welcome to the ODK forum, @jok! We're glad you're here. When you get a chance, please introduce yourself on this forum thread. I'd also encourage you to add a picture as your avatar because it helps build community!

The 2 tables is the expected behavior. It's not possible to configure briefcase to return one table. You could script a data processing workflow.

  • If using Central, there are tools such as ruODK and pyODK.
  • And then odkr says it interfaces with Briefcase and states there is a functionality to "Merge nested datasets for ODK forms with a repeat argument". (:exclamation:Note that it doesn't appear to be maintained and I don't know if it's in working condition.)

Or, the docs on repeats gives suggestions for modifying your survey design:

Using repetition in a form is very powerful but can also make training and data analysis more time-consuming. Repeats exported from Central or Briefcase will be in their own files and will need to be joined with their parent records for analysis.

Before adding repeats to your form, consider other options:

  • if the number of repetitions is small and known ahead of time, consider "unrolling" the repeat by copying the same questions several times.
  • if the number of repetitions is large and includes many questions, consider building a separate form that enumerators fill out multiple times and link the forms with some parent key (e.g., a household ID).

If repeats are needed, consider adding some summary calculations at the end so that analysis will not require joining the repeats with their parent records. For example, if you are gathering household information and would like to compute the total number of households visited across all enumerators, add a calculation after the repeats that counts the repetitions in each submission.