Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Filter a survey

Eneida33
7 - Meteor

Eneida33_0-1631112400749.png

 

Hello,

I hope someone could please be able to help me.

 

I am trying to filter a survey in alteryx.

I haven't done it before and it would be nice if you could suggest me a source to see an example. However, at the moment i have this content in one cell. 

How could I separate it in order to make sense.

 

Thank you!

 

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @Eneida33 

 

You can use text to column tool and the separator is \n.

 

Can you share a sample data and expected output over file we can help you out with it.

Eneida33
7 - Meteor

This is what i kind of have in Alteryx. 

Also, I think that this output it is understandable for the rest of the questions. The only question which I do not know which is the best way to present it is the highlighted one. I tried the text to columns but for some reason it shows me this error.

 

Eneida33_0-1631115355132.png

 

Tyro_abc
11 - Bolide

Hi

Do you want output like this?

Tyro_abc_0-1631137625347.png

 

Eneida33
7 - Meteor

Hello,

Yes that is very close to what I had in my mind. I will goo for it.

 

Thank you very much for your help.

Labels
Top Solution Authors