Hi, I have been trying to use transpose, cross tab, select data. Just cannot get my head around it
I have got Survey data that is in Rows I need to turn the column Question into Headers, there are 10 question and these will be repeated for each person. I can remove columns Question Type and Number.
Any help will be appreciated, just trying to get to grips with Alteryx.
Thanks
Disham
Question Type | Number | Learner Answer Text | Question | % | Answer |
Multiple Choice (Single Answer) | 1 | Strongly agree | Login Process | 75% | It was easy to log on and access the Virtual Classroom session... |
Multiple Choice (Single Answer) | 2 | Strongly agree | Course Experience | 75% | I could hear clearly throughout the session... |
Multiple Choice (Single Answer) | 3 | Strongly agree | Course Experience | 75% | I could clearly view all visuals and media throughout the session... |
Multiple Choice (Single Answer) | 4 | Strongly agree | Course Content | 75% | The information shared in the session was relevant and useful... |
Multiple Choice (Single Answer) | 5 | Strongly agree | Course Content | 75% | The questions posed were relevant and helped to focus my attention... |
Multiple Choice (Single Answer) | 6 | Strongly agree | The Trainer | 75% | The trainer was knowledgeable... |
Multiple Choice (Single Answer) | 7 | Strongly agree | The Trainer | 75% | The trainer was engaging... |
Free Text/Comments | 8 | socail media is the way forward | Overall | 75% | What key learning shared in this session will help you in your role? |
Free Text/Comments | 9 | no | Overall | 75% | What would your suggestions be for improving the session? |
Multiple Choice (Single Answer) | 10 | 10 - Very Likely | Overall | 75% | How likely are you to recommend others to attend this course? |
Hi @dbhamber ,
I'm not sure of your requirements, can you please provide a mock up of what you are trying to show from that data?
M.
Hi @mceleavey
I agree with @mceleavey, it sounds like the cross-tab tool should get you what you need. I'm just not clear what data you want in each of these new columns.
https://help.alteryx.com/current/designer/cross-tab-tool
Hi @dbhamber
Here is how you can arrive to the excepted output from the given data.
Workflow:
1. I am taking each required columns separately and converting them to column with number as header
2. Later i unioning the rows in order
3. While outputting i am configuring skip field names this way the header which is numbers wont be outputted.
Output:
Hope this helps 🙂