Wide export of multiselects - question ID skipping a number? | XM Community
Skip to main content

I’m running into a problem where the automatically generated question labels when I export the data (in wide format for the multiselects, as described in this post) skip a number. See screenshot below for what I’m seeing in the exported CSV, where the options count by one up until RES1_5 and then RES1_6 is skipped and the next option is labeled RES1_7. 

I think I must have created and later deleted a response option in this question that got assigned RES1_6. However, this was before any Survey Previews or generated Survey Test responses were created. No data are recorded under RES1_6. 

Is there anything I can do to fix this? I have code in R that works off an assumption that these multiselects are assigned a question ID in numeric order, with no skips, so I really would like to fix this on the Qualtrics side rather than the R side.

Perhaps you can try to recode the numbering of the options?

Yep, recoding your answers should work, and that is easy to update in your R code as well to make it look for the names of the responses that you defined. You could recode your answers to be “5, 6, 7” if you want that, or you can make them more informative like “high, medium, low” or whatever. This also lets your R code be more robust, in case you decide to add a response option, then you can just add the named new response into R as well without needing to worry about whatever random number Qualtrics assigns that response option.

 

Also I never knew that you could output multi-select questions in wide format, that’s awesome.

Terms & ConditionsAccessibility statement