Has anyone had any success using Alteryx to filter Qualtrics survey data dumps? I've been running into obstacles creating a workflow that gives me a summary of my responses.
@R_Reeves,
Thank you for the explanation and sample. Download and unpack/open the attached.
There's probably a ton of different ways to transform this, but this solution is something that should allow you to continue developing on.
I use Dynamic select tools to split the fields based on which have the string "Select all that apply" and those that don't. The top section are those that don't. What this process is doing is transforming these to show up similar to the select all questions, where each response option is in it's own column. The sub-process (highlighted in the screencap) is used to correct the headers after the cross tab tool, which replaces none letter/number chars to _.
The two streams are joined back up and the multi-field tool is just used to convert empty fields to NULLs on all text field types.
Hope this helps!JimmyTeknion Data Solutions
Hi @R_Reeves,
I do know Alteryx is commonly used to process/prepare survey data dumps, but from my experience with working with survey data, it's almost impossible to have a 'one size fits all' workflow for any type of survey data. To answer your question, I know users have successfully used Alteryx on Qualtrics survey data.
In order for this community to better assist you, detail what obstacles you're running into. If you can provide a data file (with dummy data if needed), this helps taking away some of the guess work with what you're working with and sandbox some possible solutions.
On a side note, you posted this in the Alteryx Connect board. Since your question is in regards to Designer, you'll have more users see your question of you post it in the Designer board.
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/bd-p/designer-discussions
Thanks for the quick response and redirect Jimmy! I've attached some "dummy" data to further illustrate what I'm trying to accomplish. My goal is to use Alteryx to summarize this type of data and provide percentages of responses. That is easy enough to accomplish when you only have two responses (simply count null vs. notnull). I keep getting stuck with the more complex questions. For example col. H, has 6 possible responses. Ideally I'd like to quickly glance at the report and say 20% selected about once a week, 10% selected about once a day, etc etc. I cannot figure out how to make this workflow complete this task.
