Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
vjeffers
Contributor
Contributor

Web Connector to SurveyMonkey not getting matrix of dropdown menu responses

I am using the Web Connector to SurveyMonkey to retrieve survey responses into an app. The load script generated by the web connector is not getting the responses for the question type "matrix of dropdown menus".  

LOAD
respondent_id as GetResponses_respondent_id,
question as GetResponses_question,
sub_question as GetResponses_sub_question,
answer as GetResponses_answer

Here is what the question looks like in the survey:

SM Matrix Question.PNG

The data load results in a table that loads the item statement from the first column as the sub_question, which is usual, but then repeats the item statement as the answer. There should probably be two rows for each statement as the sub_question. One as [Item statement] -In-Person Students and the other as [Item Statement] - Distance Learning Students, then with the selected answer from the dropdown menu as the answer for each row.

Is there a way to adapt the script for that result or is it out of my control? 

 

My back-up plan is to extract the data from SurveyMonkey from Excel and manually load it into my app on a weekly basis. 

Thank you.

 

 

 

 

Labels (3)
0 Replies