How Can I Find the Text Associated With Multiple Choice Question Responses?
Question
How can I find the text associated with responses to multiple choice questions?
Environment
Connector: Qualtrics
Answer
The value
column of the QUESTION_RESPONSE
table shows the number associated with the option the customer selected. For example, a value of 3
indicates the customer chose the third option. However, the value
column doesn't include the text associated with the selected option.
If your multiple choice question is a single answer variation, you can map the number in the value
column to the applicable response text by running the following query:
SELECT qr.response_id, qr.question, qr.value, qo.text
FROM <your_qualtrics_schema>.question_response qr
INNER JOIN <your_qualtrics_schema>.survey_response sr
ON qr.response_id = sr.ID
INNER JOIN <your_qualtrics_schema>.question_option qo
ON sr.survey_id = qo.survey_id
AND qr.question_id = qo.question_id
AND qr.value = qo.key
WHERE qr.response_id = '<response_id>'
AND qr.question_id = '<question_id>'
;
If this query doesn't work for you, contact our support team and we'll troubleshoot your specific use case.
It's not possible to map value
column values to the applicable response text if your multiple choice question is a multiple answer variation.