Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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

Highlighted
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 

Highlighted
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

Highlighted
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

 

2019-01-09_17-47-30.jpg

2019-01-09_17-48-02.jpg

 

Labels