Forum Discussion
Isolating a multiple choice response inside a collumn
Hi inickqc
I made a copy of the data to my drive, I couldn't connect to your drive.
I made the following steps
- Imported through the Google Sheets connector
- I promoted the Programms as the columns headers
- Removed the last two columns
- Highlighted all columns and unpivoted them.
- I removed some text from the Program names
- I also removed the .1 & .2 at the end of each program name
I loaded the data in and created the below example for you to check
https://drive.google.com/file/d/1gshoL7z6WVDxSKdeHvRBdxlJ2wgWFNvf/view?usp=sharing
Before loading the data, remove this relationship in the Model view for all tables that are linked to it. After loading in, create the relationships again. This time they will be Many to Many. Change the Cross Filter Direction to what you need
Hello
This is so great, thanks. I already accepted this as the solution, but If I can, I would ask one more question :
How do I get the Index number for each answer?
I will link the index number to the names of the people who answered, which is why I need to see the two index numbers of those who said they want to help others learn.
thanx again
Good morning inickqc
Don't delete the Index column. Highlight all columns except the Index and unpivot them. This should give you the result you need.
Kind regards
Joe
Hello,
Unfortunately, that brings me back to where I started, with an error caused by the index. See the image bellow,
Please advise.
Before loading the data, remove this relationship in the Model view for all tables that are linked to it. After loading in, create the relationships again. This time they will be Many to Many. Change the Cross Filter Direction to what you need
Sorry, I took so long to reply; I had to test and understand.
All is clear; this was a great lesson.
This should be a YouTube tutorial 🙂
Have a good day, sir!