We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Sort

BRRLL99
11 - Bolide

Hi

I have following input 

 

Thq issue has been resolved

4 REPLIES 4
ShankerV
17 - Castor

Hi @BRRLL99 

 

This can be achieved with the help of Cross-Tab tool.

 

 

ShankerV
17 - Castor

Hi @BRRLL99 

 

Please use the below configuration in the Cross Tab, 

 

Group data by these values:

ID [Tick this check box]

 

Change Column Headers

Subject

 

Values for New Columns

Marks

 

Method of Aggregating Values

Sum [Tick this check box]

 

Many thanks

Shanker V

Felipe_Ribeir0
16 - Nebula

Hi @BRRLL99 

 

One way of doing this:

transpose.png

 

 

grazitti_sapna
17 - Castor

Hi @BRRLL99 
You can crosstab the input and sort column by using Select tool. Hope it helps.

Thanks

Sapna Gupta
Labels
Top Solution Authors