community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Cross tab output in single line

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 

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

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

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