Hello! The title of this is the general idea of what I want to do, but I understand that it isn’t very simple in Qualtrics. I have a 2x80 data set for rainfall levels by province in a country. The data set is a CSV organized by province name and a rainfall amount as a number. In the survey, respondents enter their province from a drop down list. Is it possible to have a question display the rainfall amount corresponding to the entered province without me having to enter the data by hand?

If I understand the question correctly, another approach you could take would be to use a Drilldown question type with 2 levels, hide the 2nd dropdown, and then add JavaScript to the question that will automatically select the top answer in the 2nd dropdown when a selection is made in the 1st. This will give you the province's corresponding rain amount for use in piping.To give it a try, first create a CSV that has 2 columns: Province and Rainfall.Then, create a Drilldown question and set the number of choices to 2. Click to add answers and then upload the CSV file to the question.Next, add the below to the question's JavaScript in the OnReady section so that the 2nd dropdown automatically selects its 1st option when a selection is made in the 1st dropdown:var qid = this.questionId;var sel1 = document.getElementById('QR~'+qid+'~1');var sel2 = document.getElementById('QR~'+qid+'~2');jQuery(sel1).on('change', function() { sel2.options[1].selected = true;});Finally, add the below CSS to the Style section of the Look & Feel so that the 2nd dropdown is not displayed to the respondent.div.Inner.BorderColor.DL > div > fieldset > div > table > tbody > tr:nth-child(2) {display: none;}Later in the survey, you can pipe in the 2nd dropdown selection/Rainfall amount by using the below, updating for your QID:${q://QID1/ChoiceGroup/SelectedAnswers/2}

Hello @krbhavya! Thanks for the reply. I’m not sure I exactly understand. You mean I can create embedded data in one supplemental data source than connect that SDS to the survey as embedded data? If yes, how can I do this exactly.

Uploading data from a CSV file in a question's piped text

Uploading data from a CSV file in a question's piped text | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded