Storing Multi-Select Responses and Responses with HTML Formatting in Directories

Question

Hello, I am in the process of finalizing a directory setup that is fed by a survey. The survey feeds the directory via a workflow (specifically via embedded fields). I’ve tested multiple times and 90% of the fields are filing/logging in the directory correctly. However, there are 2 items giving me trouble: For one of the questions in the feeder survey, the answer options are formatted with bold and coloring/italics, as shown below. Fruit (Apples, blueberries, bananas) Other fruit includes strawberries, blackberries, etc. Veggies (Peppers, carrots, onions) Other veggies include potatoes, spinach, etc. The only value I want in the directory is the category in bold (e.g., Fruit, Veggies). Instead it logs the full option as shown below, even after I recoded the values (and variable names) in the survey. Fruit
(Apples, blueberries, bananas)
Other fruit includes strawberries, blackberries, etc. The other question giving me trouble is when I try to log a multi-select question in the directory (example question below). Instead of Qualtrics creating a column for each option, like it does with multi-select questions in survey raw data exports, it combines all selections into a single column as a string. So, if the respondent selects “Canada” and “Mexico” for example, it will store in the directory as a single column with a value of “Canada, Mexico”. Instead, I would like it to store as: Q_Canada Q_Mexico Q_Columbia Q_Peru Q_None Canada Mexico [Blank] [Blank] [Blank] EXAMPLE QUESTION FOR ABOVE SCENARIO: Which country (or countries) have you had fruits or vegetables from? Select all that apply.Canada Mexico Colombia Peru None of these [EXCLUSIVE] Please note that all examples above are hypothetical, so precise code might not apply. Thank you for your help!

Chee Heng_SZ · Answer

Hi ​@jdaker,For (1), perhaps you can have branch logic to check if the selection contains the word “Fruit”, if it does, create an embedded data with value “Fruit”. When updating to directory, use the embedded data instead of the selected choice as piped text.Update on (2):Sorry, I misunderstood your question earlier.Perhaps a similar approach to (1) as well.For (2), when you export the raw data, you can enable “Split multi-value fields into columns”.More information: Data Export OptionsFor (3), set the MCQ to be multiple answer, select the choice to be made exclusiveand select make answer exclusive.Hope these helps.

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded