In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

rearranging output

imrahu01
8 - Asteroid

Hello All,

I need some help. I am trying to rearrange my output. is there any way I can get my output rearranged by showing state name as a column header? I want my output to look like (PIVOT DATA-Copy).

 

rahat

3 REPLIES 3
terry10
12 - Quasar

Did you already try the Crosstab tool?

deviseetharaman
11 - Bolide

Hi @imrahu01 

 

Please use cross tabs as @terry10  suggested. Here is an attempt to arrive at the Pivot output. There is other elegant ways to do it with tables. I will explore them when I have time. This can get you started. 

imrahu01
8 - Asteroid

Wow!!! this one looks amazing. THANK YOU @deviseetharaman ðŸ™‚

Labels
Top Solution Authors