Data tabulation and percentage

[Edu_XGomes]

Hi people, how are you, I hope very well!

Guys I am new using the alteryx software here at work and I have many demands on this that I can´t solve that´s why I would like to get your help. Please take a look in my input data and my output data, is it possible get this kind of output in Alteryx? If yes, please, how/?

[DultonM · Accepted solution]

Hi @Edu_XGomes,

Welcom to Alteryx! You can definitely get the output you need with Alteryx!! The Transpose tool with no key fields selected will allow you get the data from your multiple columns into one column. You can then use the Group By and Count options in the Summarize tool to collapse the data down to just:

mother	2
dad	3
brother	2

A combination of a Summarize, Append, and Formula tools can get you the percentage column. I attached a workflow that gets your desired output, both with and without a total row. Check out how the data changes from one tool to the next; you'll see the role each tool plays in arriving at the answer. Let me know if you have any questions! Please mark if this solves your inquiry!

[Edu_XGomes]

Thanks you DultonM Now it is working as well

I have worked on SPSS for so long time, now I am going on Alteryx!