Multiple choice questions best format in Alteryx

[sarasustelosantos]

Hello all,

My plan is to go from what's on the left to the right (see figure below).

I have multiple questions answers delimited by commas so I did text to rows, but from that step how can I create the dummy variables in case the respondent had selected that choice is 1 and if not is 0?

Thank you in advance.

...

[atcodedog05 · Accepted solution]

Hi @sarasustelosantos 

Here is how you can do it.

Workflow:

Hope this helps : )

[sarasustelosantos]

Thank you 🙂

[atcodedog05]

Happy to help : ) @sarasustelosantos 

Cheers and have a nice day!