And Jacquie, odkmeta can do a lot of the hard work for you if you're using Stata. Check it out here:
https://ideas.repec.org/c/boc/bocode/s457767.html
Chris
Christopher Robert
Dobility, Inc. (SurveyCTO)
http://www.surveycto.com/
http://blog.surveycto.com/
You should talk to your organization's data analysts. This is a standard analysis circumstance.
Tools like STATA should allow you to import multiple data sets and establish relationships among those data sets (e.g., PARENT_KEY in this data set corresponds to KEY in that data set).
Mitch (and/or others),
I was having the same problem. I used ODK Briefcase and downloaded the data, and it did exactly as you said--putting the top level survey and all repeat groups in separate Excel files.
Now, I want to know how to deal with having separate files during data analysis. I want to be able to analyze all the births from all women in my survey by educational level, wealth quintile, total parity, location, etc.--all variables contained in my top level survey. How do I do that? Do I have to manually compile all the excel files into one single spreadsheet? I'm wanting to use a stats program like Stata to analyze, if that's pertinent...
Thanks for your help!
Jacquie
Use ODK Briefcase.
After downloading the dataset to your computer, you can export data as a CSV. That would produce a csv for the top-level survey, and a csv for each repeat group within that survey. If you had just one repeat group in your survey, it would produce two csv files and you would use the REF and PARENT_REF columns to tie the two generated csv files together.
Dear all,
I built a
form with a “repeat” statement after a couple of preliminary questions. When I
enter in the repeat cycle, let us suppose that I need to repeat the cycle 3
times. The problem is that when I download the CSV file, the inserted answers appear
as a single line (with a weblink instead of the three answers to the repeat
cycle questions). Is there a way to export the csv file with each answer inside
the repeat cycle expanded on multiple lines?
Thank you
in advance
Laura
--
--
Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to the Google Groups "ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to opendatakit...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com
--
--
Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to the Google Groups "ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to opendatakit...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com
--
--
Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to the Google Groups "ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to opendatakit...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Thank you for your help! Much appreciated.