Best Option for Piping Text Specific to Respondent From Contact List

Hi @JCF_76 ,

You're on the right track, but just need to do two more things.

First, when you insert the embedded data into your question, in place of "Surgeon 1" it should have the following code: ${e://Field/Surgeon}

The interface in Qualtrics can be a little wonky but you'll have to overwrite the text you have there currently when you insert the code for the embedded data field.

However, if you want to pipe in names for all 10 surgeons into a separate row, you'll need to change your source file/contact list so that each surgeon is in a separate column (e.g., Surgeon1, Surgeon2, Surgeon3, etc.). Then when you pipe in the code the rows would read ${e://Field/Surgeon1}, ${e://Field/Surgeon2}, etc.

Hope this helps!

Matthew,

So, I do want to be able to pipe in all names, and actually a bit more data. essentially I want to pipe the info in Row 2 in the below screenshot:

!

Did I set up my merge file correctly with each column now representing a surgeon?

For the embed instructions what would it be if I wanted to PIPE in Cell B2, Cell B3, Cell B4...etc.

Each Cell would comprise the piped text for a row, e.g., Cell B2 should pipe into 'Surgeon 1', if I were to continue using my screen shot example from up above.

Hope this makes sense?

Thanks!!!!

Hi,

To prepopulate the embedded data into your survey, you'll have to transform your datafile to be really wide and note that only the header row (row 1) can be used to prepopulate into the survey. So your datafile will have a series of columns from Surgeon1 through Surgeon10, NPI1 through NPR10, Main Product Group1 through Main Product Group10, and so on.

Also note that you should remove the "Code" row from your file; although you can write the code yourself directly in the survey, Qualtrics can also generate that itself when you insert each field into your survey.

Sorry I'm not explaining this clearly. No, your data file will have the field names/column headers in row 1, and data below that in rows 2 to N (with N being the total number of target respondents in your contact list). Each target respondent's data should be in a separate, single row.

Rows 1 and 2 in your screen shot would not apply to this.

I've attached an example Excel file. Row 1 has data from your screen shot; row 2 is additional data I made up for subsequent respondents.