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