Exporting Coded Verbatim Responses (Topics)

Question

Hi All,

Does anyone have any experience with coding verbatim responses (what Qualtrics calls Topics in Text Analysis/TextiQ) and then exporting these topics.

It seems to export all the topics for each individual respondent into one field (or one cell in Excel).  To actually make analysis easier, what you really need is a separate column for each code (ideally with a 1 or 0 - but even just the text in separate columns would help).

For example, if I have 3 Topics:
Safety
Technology Benefits
Environmental Benefits

If these are all coded for a response by one respondent, what you get is:
Safety, Technology Benefits, Environmental Benefits in one cell in Excel.

You can use the Text to Columns function in Excel, which will separate these into separate columns... but the problem is if you have another respondent whose response was coded to: Safety, Environmental Benefits

Then you will have a column which has Safety for each respondent, but the next column will have Technology Benefits for the first respondent and Environmental Benefits for the second respondent....

So there is more manual sorting of the data required in Excel.....

Anyone found a way to overcome this yet?

When exporting the data I did select: Split multi-value fields into columns, but this doesn't seem to work for Topics.

Any help greatly appreciated.

Thanks, 
John

AnthonyR · Accepted Answer

@john_shearer Unfortunately, there is no way to split these on export. We process after export for this kind of problem.

AnthonyR · Answer

@john_shearer I think the way you are currently handling it isn't a terrible solution. What you may consider is just making a column for each topic and checking for the "existence" of a topic for a person in the merged column. Since you can then use this repeatable formula, you won't have to nest nearly as much to populate your updated columns. =IF(ISNUMBER(SEARCH("category",originalColumn)), 1, 0)

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded