Exporting Combo - Recode Values for Most Fields and Text Labels for a Few | XM Community
Skip to main content

Greetings,

I am new to the Qualtrics platform, but have been working with surveys for a while. I have a survey that is mostly likert scale-style questions but also one (or two) questions that are Multiple Choice (pick one/drop downs) that have a text value that I want to see in my export. Basically, it’s organization name (open text), department (drop-down list), q1 (recode), q2 (recode) etc..

I want my export to include Department Names field as text and then use the recode values for the all of the remaining question fields. It seems like it should be a relatively straight forward need. 

I see that when exporting I can pick either numeric values or choice text. Is there no way to export with both? Or should I be setting the survey itself up differently (e.g. using a different question type for the department value),  althoughI do need to use standardized values for Department.

I have tried setting Department to Variable Name in the question setup, but that doesn’t seem to make a difference.

I would basically like it to export the way it looks onscreen (see below - but there are about 20 questions that follow)

Any advice?

Best,
Kim

 

 

Ah! I think I figured this out, and will answer this here in case anyone else struggles with this. Here’s how I did this

  1. Go to Survey Flow
  2. Follow these instructions to add an Embedded Data - field and position it after the field that is being referenced. The new Embedded Data field is called “DepartmentName”
  3. When setting the value > Insert Piped Text > Survey Question > selected “Department” as the question and then Selected Choices. It ended up looking like this: ${q://QID2/ChoiceGroup/SelectedChoices}
  4. Check that the data field has the “Variable Naming” checkbox checked.
  5. Once in Data & Analysis, use the Column Chooser to add the Embedded Data field to the Data Table

Leave a Reply


Terms & Conditions