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
Best answer by AnthonyR
View original