Data Analysis

When I export data from aggregate to csv, it only exports the id not the
text value for all the select_multiple fields. How do I get the text.
Should I use another method for analysis

Anthony

Correct. The data captured is the value code for the selection choice, not
the text label for that choice. Labels might be translated into many
different languages; it does not make sense to use the label in the output.

Given your original survey, especially if you use XLSForm, you should be
able to use the Excel functions VLOOKUP() or HLOOKUP() (I forget which...)
to map the value code back to a label of your choice.

That's actually one of the advantages of using XLSForm over Build -- you
have a sheet providing the mapping from the choice value codes -to- the
labels, so it is quite straightforward to define the mapping back to a
label if you need to.

Mitch

ยทยทยท On Mon, Mar 25, 2013 at 1:17 PM, Muyepa A. wrote:

When I export data from aggregate to csv, it only exports the id not the
text value for all the select_multiple fields. How do I get the text.
Should I use another method for analysis

Anthony

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@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+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com