I noticed that when I select "expand multiple choice questions" with a form export, an additional column 'data | extra' appears. Is this expected behavior?
Why does ‘Extra’ appear if you select ”Expand Multiple Choice Questions”
commcare
Related Topic
- Saving location name from multiple choice lookup table as a case property
- Multi-language support for Multiple Choice Lookup Table questions
- Dashboard not being populated after data migration
- CommCareHQ Exports to display in the Order they Appear in Form Builder
- In CommCare can the question labels in the data export to be set to a non default-language
- Referencing Columns in CommCare – How to Use Lookup Table in Display Condition
- Time discrepancies in a form export
Best Answer
This is indeed expected behavior. The "extra" column is for any options that were chosen that were not found in the list of specified options in the application. Suppose you have the following multiple choice options defined:
If CommCare sees an answer that is
D
. It will put it in the "extra" column.This can often happen when a user changes the options in their application. For example, if one were to deploy an app with the following options:
Then in a later version change that question to only accept:
Any forms that had already answered D will show up in the "extra" column.