Alteryx Designer Discussions

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

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!

Cross tab output in single line

8 - Asteroid

Hi , 

I am quite new to alteryx and any help will be much appreciated ,

I am attaching my given input and the desired  output.

I used Cross tab in my workflow , to swap row data to column.

i realised its giving output in different lines. i wish to get the output for one category in single line.

Help me 

16 - Nebula
16 - Nebula

There are two easy ways to do this.


First way is to Transpose and then Cross Tab back


Perhaps the easiest way is just to use a summarise tool and group by and then sum


Samples attached

8 - Asteroid

Thank you so much , this worked perfectly fine.. but if i have some more columns name then how we need to modify the workflow.

Please help.

I am attaching the input and output

Best Regards

16 - Nebula
16 - Nebula

All you need to do is to change the Key fields in the Transpose and Group By field in the Cross Tab