Data Structure with Question Items

Question

I’m reviewing data issues pulled from our API integration with Qualtrics and trying to identify the root issue. (See attached image). We have four options in this particular survey. You can see the recode values on the left. On the right-hand side is what the individual responded, with “Y” being what was selected. As you can see, some users have “N” across all options, despite having selected an option. In the row highlighted, the user selected the second option, was awarded a score for it, yet in the “answer” option, it is not appearing.My guess is that this is due to the survey item option responses changing. For example, when creating a new item with 4 options, it populates options as option1, 2, 3, and 4. If you delete Option 1, and create a new option, it comes up as “option 5” rather than replacing option 1. Thus, if we are only capturing Answers 1-5, it may not be matching with Options 1-5.Is there a way to change the options back to 1-5? Another way of looking at it - if the original item had four options (options 1-4). I removed the first two, then added two more, so now the item would say it has options 3, 4, 5, 6.Follow me?Is there a way to convert option 5 and 6 to now be “option 1” and “option 2” or is this something we need to address through our API? If the latter, does anyone have documentation on this?

ahmedA · Answer

The dataset you get is mapped to the current published version of the survey.If you’ve made changes to your survey and finding issues as you’ve indicated, one option could be to go back to the survey version that the respondents took, publish it, and then pull your data again.

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded